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.
Комментариев нет:
Отправить комментарий