Populate ListBox from SqlDataSource
ListBox is a Standard ToolBox Control. In this simple example here I show how to populate ListBox with SqlDataSource.
First create a WebForm name ListBoxSqlDataSource.aspx. Then add a SqlDataSource Control, a ListBox Control and a Label Control. I save a ConnectionString in web.config file and use it for SqlDataSource ConnectionString property. In this example I use the NorthWind database. Here is the source code of ListBoxSqlDataSource.aspx file.
First create a WebForm name ListBoxSqlDataSource.aspx. Then add a SqlDataSource Control, a ListBox Control and a Label Control. I save a ConnectionString in web.config file and use it for SqlDataSource ConnectionString property. In this example I use the NorthWind database. Here is the source code of ListBoxSqlDataSource.aspx file.
<%@ Page Language="C#" %>
<!DOCTYPE html>
<script runat="server">
protected void ListBox1_SelectedIndexChanged(object sender, System.EventArgs e) {
Label1.Text ="You selected: " +
ListBox1.SelectedItem.Text.ToString();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>ListBox Example: How to populate ListBox from SqlDataSource</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:SqlDataSource
ID="SqlDataSource1"
runat="server"
ConnectionString="<%$ ConnectionStrings:AppConnectionString %>"
SelectCommand="SELECT [ProductName] FROM [Products]"
>
</asp:SqlDataSource>
<asp:Label ID="Label1" runat="server" Font-Size="Large" ForeColor="BlueViolet"/>
<br /><br />
<asp:Label ID="Label2" runat="server" Text="Choose one"></asp:Label>
<br />
<asp:ListBox
ID="ListBox1"
runat="server"
AutoPostBack="True"
OnSelectedIndexChanged="ListBox1_SelectedIndexChanged"
DataSourceID="SqlDataSource1"
DataTextField="ProductName"
DataValueField="ProductName"
>
</asp:ListBox>
</div>
</form>
</body>
</html>

