вторник, 28 сентября 2010 г.

SqlDataSource Optional Parameters

I want to use it to populate a GridView, but using an optional parameter to filter the results.

One way to do this is to use Optional Parameters: http://steve.emxsoftware.com/Optional+Parameters+in+SQL+Server+Search+Queries.

If you adopt this approach, make sure to set the CancelSelectOnNullParameter property of your DataSource control to false.

Комментариев нет: