filtered query with dropdown control

[Spartaco]

I have a dropdown control into a page and a gridview, both are associated to
two SqlDataSource controls, one of them is used to fill the DropDownControl ,
that is meant to be a filter over the query of the other SqlDatasource
associated to the grid. This works fine, whenever I choose an item in the
dropdown combo, I get a filtered grid.

I did this using the declarative syntax, without writing any code. ok, now I
want to put another item at the top of the combobox, to get an unfiltered
list, so the question is:

is there a fast way of doing this ? I could think about handling the
SelectedIndexCh anged event of the combo to change the datasource of the grid
or the query used, but i would like to know if there was a more elegant and
faster way of doing this, with a declarative syntax, by using some unknown
property of the grid or datasource controls, or changing the select query.

thanks

[pickedaname]

Here's how I did mine....
On the dropdownlists databound event, use this:
DropDownList1.I tems.Insert(0, "All Results...")
(or whatever you want the text to be. 0 is the zero based item index of the
control.)
Then on the ddl's selectedindexch anged event, check the value
IF ddl1.SelectedVa lue = "All Results..." THEN
SqlDataSource1. SelectCommand = "select * from table order by col1"
SqlDataSource1. DataBind()
ELSE
SqlDataSource1. SelectCommand = "select * from table where col2 = '" &
ddl1.selectedva lue & "' order by col1"
END IF

Also make sure autopostback is enabled for the ddl control.

"Spartaco" wrote:

I have a dropdown control into a page and a gridview, both are associated to
two SqlDataSource controls, one of them is used to fill the DropDownControl ,
that is meant to be a filter over the query of the other SqlDatasource
associated to the grid. This works fine, whenever I choose an item in the
dropdown combo, I get a filtered grid.

I did this using the declarative syntax, without writing any code. ok, now I
want to put another item at the top of the combobox, to get an unfiltered
list, so the question is:

is there a fast way of doing this ? I could think about handling the
SelectedIndexCh anged event of the combo to change the datasource of the grid
or the query used, but i would like to know if there was a more elegant and
faster way of doing this, with a declarative syntax, by using some unknown
property of the grid or datasource controls, or changing the select query.

thanks

[pickedaname]

sorry forgot the datasource databind() function in ELSE

"pickedanam e" wrote:

Here's how I did mine....
On the dropdownlists databound event, use this:
DropDownList1.I tems.Insert(0, "All Results...")
(or whatever you want the text to be. 0 is the zero based item index of the
control.)
Then on the ddl's selectedindexch anged event, check the value
IF ddl1.SelectedVa lue = "All Results..." THEN
SqlDataSource1. SelectCommand = "select * from table order by col1"
SqlDataSource1. DataBind()
ELSE
SqlDataSource1. SelectCommand = "select * from table where col2 = '" &
ddl1.selectedva lue & "' order by col1"
END IF

Also make sure autopostback is enabled for the ddl control.

"Spartaco" wrote:

I have a dropdown control into a page and a gridview, both are associated to
two SqlDataSource controls, one of them is used to fill the DropDownControl ,
that is meant to be a filter over the query of the other SqlDatasource
associated to the grid. This works fine, whenever I choose an item in the
dropdown combo, I get a filtered grid.

I did this using the declarative syntax, without writing any code. ok, now I
want to put another item at the top of the combobox, to get an unfiltered
list, so the question is:

is there a fast way of doing this ? I could think about handling the
SelectedIndexCh anged event of the combo to change the datasource of the grid
or the query used, but i would like to know if there was a more elegant and
faster way of doing this, with a declarative syntax, by using some unknown
property of the grid or datasource controls, or changing the select query.

thanks