Expand|Select|Wrap|Line Numbers
- <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="dsNames"
- DataTextField="Name" DataValueField="Id">
- </asp:DropDownList>
- <asp:SqlDataSource ID="dsNames" runat="server"
- ConnectionString="<%$ ConnectionStrings:dbProfilesConnectionString %>"
- SelectCommand="SELECT Lname+', '+Fname AS Name,Id FROM tblProfile">
- </asp:SqlDataSource>