Bind data source to asp:DropDownList
<%@ Page Language="VB" %>
<script runat="server">
Function AllPublishers() As System.Data.SqlClient.SqlDataReader
Dim connectionString As String = "server='(local)\NetSDK'; trusted_connection=true; Database='pubs'"
Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString)
Dim queryString As String = "SELECT [publishers].* FROM [publishers]"
Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)
sqlConnection.Open
Dim dataReader As System.Data.SqlClient.SqlDataReader = sqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
Return dataReader
End Function
Sub Page_Load(sender As Object, e As EventArgs)
Page.DataBind()
End Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<p>
<asp:CheckBoxList id="CheckBoxList1" runat="server" DataSource="<%# AllPublishers() %>" DataTextField="pub_name" DataValueField="pub_id"></asp:CheckBoxList>
</p>
<p>
<asp:RadioButtonList id="RadioButtonList1" runat="server" DataSource="<%# AllPublishers() %>" DataTextField="pub_name" DataValueField="pub_id"></asp:RadioButtonList>
</p>
<p>
<asp:DropDownList id="DropDownList1" runat="server" DataSource="<%# AllPublishers() %>" DataTextField="pub_name" DataValueField="pub_id"></asp:DropDownList>
</p>
<p>
<asp:ListBox id="ListBox1" runat="server" DataSource="<%# AllPublishers() %>" DataTextField="pub_name" DataValueField="pub_id"></asp:ListBox>
</p>
<p>
<asp:Repeater id="Repeater1" runat="server" DataSource="<%# AllPublishers() %>">
<HeaderTemplate>
<b>Publisher List:</b>
<br />
</HeaderTemplate>
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "pub_name") %> (ID: <%# DataBinder.Eval(Container.DataItem, "pub_id") %>) <font size="-1"><i> <%# DataBinder.Eval(Container.DataItem, "city") %>, <%# DataBinder.Eval(Container.DataItem, "state") %>, <%# DataBinder.Eval(Container.DataItem, "country") %>
<br />
</i></font>
</ItemTemplate>
</asp:Repeater>
</p>
<p>
<asp:DataList id="DataList1" runat="server" DataSource="<%# AllPublishers() %>">
<ItemTemplate>
<p>
ID:
<asp:Label id="Label6" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "pub_id") %>'></asp:Label>
Name:
<asp:Label id="Label7" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "pub_name") %>'></asp:Label>
</p>
<p>
Address:
<asp:Label id="Label8" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "city") %>'></asp:Label>
,
<asp:Label id="Label9" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "state") %>'></asp:Label>
,
<asp:Label id="Label10" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "country") %>'></asp:Label>
</p>
</ItemTemplate>
<HeaderTemplate>
<asp:Label id="Label1" runat="server" Font-Names="Tahoma" Font-Italic="True">List of publishers:</asp:Label>
<hr />
</HeaderTemplate>
<FooterTemplate>
<hr />
</FooterTemplate>
<SeparatorTemplate>
<hr />
<span style="WIDTH: 100%; HEIGHT: 100%">
<div contenteditable="true" style="PADDING-RIGHT: 8px; PADDING-LEFT: 8px; PADDING-BOTTOM: 8px; WIDTH: 100%; PADDING-TOP: 8px; HEIGHT: 100%"></div>
</span>
</SeparatorTemplate>
</asp:DataList>
</p>
</form>
</body>
</html>
Related examples in the same category
