How dynamically add WHERE clause to sqldatasource

  • Thread starter Thread starter Cirene
  • Start date Start date
C

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!
 
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.
Click to expand...

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.
 
Back
Top