How dynamically add WHERE clause to sqldatasource

[Cirene]

I have a gridview that is filtered by a databound dropdownlist. I've set
AppendDataBound to True and added the item "ALL" in the dropdownlist.

My gridview is supposed to be filtered by this dropdownlist.

When it's "ALL" I want to include everything. When it's something else I
want to filter the gv data by this dropdownlist.

Do I need to dynamically change the WHERE clause via code? I'm sure there's
an easier way to do this.

Please let me know....

Thanks!

 

[MasterGaurav \(www.edujini-labs.com\)]

Do I need to dynamically change the WHERE clause via code? I'm sure

there's an easier way to do this.

Yes.
AFAIK, there's no other alternative.
Can do it in Page.Load event.


--
Cheers,
Gaurav Vaish
www.mastergaurav.com
www.edujini-labs.com
-------------------------------

 

[Larry Bud]

I have a gridview that is filtered by a databound dropdownlist. I've set
AppendDataBound to True and added the item "ALL" in the dropdownlist.

My gridview is supposed to be filtered by this dropdownlist.

When it's "ALL" I want to include everything. When it's something else I
want to filter the gv data by this dropdownlist.

Do I need to dynamically change the WHERE clause via code? I'm sure there's
an easier way to do this.

In your 'where' clause, add a parameter of @dropdown (or whatever you
want to call it)...

where (dropdown=@dropdown or @dropdown='All')

What I usually do is if your column that you're querying is an
integer, my default value for the dropdown will be 0 (zero), otherwise
I usually make it ALL or A.