Hi,

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.

TIA!



PS I've tried using the ObjectDataSource's post-bind filtering, and it doesn't work properly

Try altering the SP to show both

If @PAram is Null
 Begin
   SELECT * FROM TableName
 End
Else
 Begin
   SELECT * FROM TableName WHERE Param1 = @Param1 and Param2 = @Param2
 End

This should Work

Cheers:)
Shasur

http://www.vbadud.blogspot.com