Author: stovey | Posted on: 2/2/2009 3:54:15 PM | Views : 481

 Hi everyone. So what im trying to do is create a dropdownlist filter system binded to a sqldatasource. I've got it working fine except for one issue; i would like to have an 'all' list item in the ddl which when selected returns all of the values in the column. Here's a snippet of my code:
<asp:DropDownList ID="dd_title" runat="server" DataSourceID="ddDataSource"
    DataTextField="Title" DataValueField="Title" CssClass="dd_style" AppendDataBoundItems="True">
        <asp:ListItem Value="">Any</asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="ddDataSource" runat="server"
     ConnectionString="<%$ ConnectionStrings:JobsConnectionString %>"
     SelectCommand="SELECT DIST ...

Go to the complete details ...