GridView SQL Datasouce - Parameters

[tektipster79]

I have a SQL Datasource attached to a GridView. The SQL Datasource accepts a few parameters. I'm trying to provide sort of multiple filtering capabilities. So I may need to include logic to filter on only one parameter, not both. Is it possible for me to use the same SQL Datasource for all of my filtering cases and just send a value for one of the parameters that will bring back all values? For example, if my filtering options are for filtering cars based on color and brand, and I choose to only filter on color, can I send a value for the brand parameter that will bring back all brands?

 

[Craig0201]

Wildcards and LIKE are your friend.

C

 

[tektipster79]

Can I send a wildcard value as a SelectParameter though?

 

[Craig0201]

Yes......

cmd.Parameters.AddWithValue("test","%%")

C