Author: Square1 | Posted on: 3/21/2010 9:26:08 PM | Views : 234

Hi all:
 
I have a drop down list as follows:
 
<asp:DropDownList ID="List_Players" runat="server" DataSourceID="SqlDataSourcePlayers" DataTextField="Player" DataValueField="Player" appenddatabounditems="True"> <asp:ListItem value="-1" text=""> </asp:ListItem> </asp:DropDownList> <asp:SqlDataSource ID="SqlDataSourcePlayers" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionStringReadOnly %>" SelectCommand="SELECT DISTINCT Events.Player FROM Events WHERE EventDate >= convert(char(24), getdate(),1) ORDER BY Events.Player"> </asp:SqlDataSource> This is working fine. But I need to complicate th ...

Go to the complete details ...