I have a Gridview on my aspx page that is filtered based on a series of fields.
One of these fields is a drop down list 'Status' the options are; 'Read', 'Unread' and 'Both'.
The SQL Stored Procedure expects serveral parameters including a bit parameter for the field 'Read'.
If the Drop Down list has Read or Unread in it my Stored Parameter works but if it has Both in I am not sure what to pass to the Stored Procedure to get it to give me all records or basically ignore the Read field.
Can anyone help?
View Complete Post