c# - Getting a dropdown to interact with a gridview -

i have gridview looks this:

<asp:gridview id="gridview1" runat="server" autogeneratecolumns="false"  pagesize="10"         datakeynames="id"          onrowediting="gridview1_rowediting"         onrowcancelingedit="gridview1_rowcancelingedit"         onrowupdating="gridview1_rowupdating"         onpageindexchanging="gridview1_pageindexchanging"         onpageindexchanged="gridview1_pageindexchanged"         allowpaging="true"> 

works fine. want add dropdown box above gridview act filter database results:

<asp:dropdownlist id="dropdownlist1" runat="server" autopostback="true">     <asp:listitem value="0">show all</asp:listitem>     <asp:listitem value="1">in queue</asp:listitem>     <asp:listitem value="2">being worked on</asp:listitem>     <asp:listitem value="3">complete</asp:listitem>     <asp:listitem value="4">declined</asp:listitem> </asp:dropdownlist> 

how dropdown interact gridview update results accordingly? keeping in mind gridview has paging enabled, dropdown option should remembered when pages clicked on , database results should remembered based on page number , dropdown selection.

update:

i populate gridview follows binddata goes page_load:

private void binddata() {      sqlconnection con = new sqlconnection(configurationmanager.appsettings["connstring"]);     sqldataadapter da = new sqldataadapter(@"sql query here", con);      datatable dt = new datatable();     da.fill(dt);      gridview1.datasource = dt;      gridview1.databind();  } 

page_load looks this:

protected void page_load(object sender, eventargs e) {     if (!ispostback)     {         binddata();     } } 

in binddata() method need pass filter value dropdownlist1 if 1 has been selected , amend sql accordingly. may need pass requested page number in sql statement results can filtered in select (depending on how doing paging haven't stated).

then in autopostback method dropdownlist1 call binddata().

this way each time drop down list value changed call binddata() method , pas relevant filters , page number relevant results.