ObjectDataSource and Wildcards
How can I pass a wildcard to a stored procedure (via BLL and then DAL) with objectdatasource?
I have two parameters in the sproc, one is integer, the other boolean.
The sproc is of the form SELECT * FROM TableName WHERE Param1 = @Param1 and Param2 = @Param2.
On initial load, I want my GridView to show all values (i.e. substituting sproc params for *), and then allow the user to filter the data using control parameters and dropdownlists.
PS I've tried using the ObjectDataSource's post-bind filtering, and it doesn't work properly