<asp:DropDownList ID="ddlLastName" DataSourceID="SqlDataSource2" AutoPostBack="True" DataValueField="LastName" runat="server" Width="120px" Font-Size="11px" AppendDataBoundItems="True" DataTextField="LastName"> <asp:ListItem Text="All" Value="%"></asp:ListItem> </asp:DropDownList> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:XXXConnectionString %>" SelectCommand="SELECT [LastName] FROM [Names] WHERE ([Site] = @Site) ORDER BY [LastName]"> <SelectParameters> <asp:ControlParameter ControlID="TextBox1" Name="Site" PropertyName="Text" Type="String" /> </SelectParameters> </asp:SqlDataSource>
AppendDataBoundItems="True"
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)