http://nfex.ru/index.php?action=history&feed=atom&title=ASP.Net%2FADO.net_Database%2FListBox
ASP.Net/ADO.net Database/ListBox - История изменений
2026-04-29T19:46:50Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://nfex.ru/index.php?title=ASP.Net/ADO.net_Database/ListBox&diff=1566&oldid=prev
в 15:30, 26 мая 2010
2010-05-26T15:30:47Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 15:30, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://nfex.ru/index.php?title=ASP.Net/ADO.net_Database/ListBox&diff=1567&oldid=prev
Admin: 1 версия
2010-05-26T11:50:42Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Bind data source to asp:ListBox==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="VB" %><br />
<script runat="server"><br />
Function AllPublishers() As System.Data.SqlClient.SqlDataReader<br />
Dim connectionString As String = "server="(local)\NetSDK"; trusted_connection=true; Database="pubs""<br />
Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString)<br />
<br />
Dim queryString As String = "SELECT [publishers].* FROM [publishers]"<br />
Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)<br />
<br />
sqlConnection.Open<br />
Dim dataReader As System.Data.SqlClient.SqlDataReader = sqlCommand.ExecuteReader(System.Data.rumandBehavior.CloseConnection)<br />
<br />
Return dataReader<br />
End Function<br />
<br />
Sub Page_Load(sender As Object, e As EventArgs)<br />
Page.DataBind()<br />
End Sub<br />
</script><br />
<html><br />
<head><br />
</head><br />
<body><br />
<form runat="server"><br />
<p><br />
<asp:CheckBoxList id="CheckBoxList1" runat="server" DataSource="<%# AllPublishers() %>" DataTextField="pub_name" DataValueField="pub_id"></asp:CheckBoxList><br />
</p><br />
<p><br />
<asp:RadioButtonList id="RadioButtonList1" runat="server" DataSource="<%# AllPublishers() %>" DataTextField="pub_name" DataValueField="pub_id"></asp:RadioButtonList><br />
</p><br />
<p><br />
<asp:DropDownList id="DropDownList1" runat="server" DataSource="<%# AllPublishers() %>" DataTextField="pub_name" DataValueField="pub_id"></asp:DropDownList><br />
</p><br />
<p><br />
<asp:ListBox id="ListBox1" runat="server" DataSource="<%# AllPublishers() %>" DataTextField="pub_name" DataValueField="pub_id"></asp:ListBox><br />
</p><br />
<p><br />
<asp:Repeater id="Repeater1" runat="server" DataSource="<%# AllPublishers() %>"><br />
<HeaderTemplate><br />
<b>Publisher List:</b><br />
<br /><br />
</HeaderTemplate><br />
<ItemTemplate><br />
<%# 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 />
<br /><br />
</i></font> <br />
</ItemTemplate><br />
</asp:Repeater><br />
</p><br />
<p><br />
<asp:DataList id="DataList1" runat="server" DataSource="<%# AllPublishers() %>"><br />
<ItemTemplate><br />
<p><br />
ID: <br />
<asp:Label id="Label6" runat="server" Text="<%# DataBinder.Eval(Container.DataItem, "pub_id") %>"></asp:Label><br />
&nbsp;Name: <br />
<asp:Label id="Label7" runat="server" Text="<%# DataBinder.Eval(Container.DataItem, "pub_name") %>"></asp:Label><br />
</p><br />
<p><br />
Address: <br />
<asp:Label id="Label8" runat="server" Text="<%# DataBinder.Eval(Container.DataItem, "city") %>"></asp:Label><br />
, <br />
<asp:Label id="Label9" runat="server" Text="<%# DataBinder.Eval(Container.DataItem, "state") %>"></asp:Label><br />
, <br />
<asp:Label id="Label10" runat="server" Text="<%# DataBinder.Eval(Container.DataItem, "country") %>"></asp:Label><br />
</p><br />
</ItemTemplate><br />
<HeaderTemplate><br />
<asp:Label id="Label1" runat="server" Font-Names="Tahoma" Font-Italic="True">List of publishers:</asp:Label><br />
<hr /><br />
</HeaderTemplate><br />
<FooterTemplate><br />
<hr /><br />
</FooterTemplate><br />
<SeparatorTemplate><br />
<hr /><br />
<span style="WIDTH: 100%; HEIGHT: 100%"> <br />
<div contenteditable="true" style="PADDING-RIGHT: 8px; PADDING-LEFT: 8px; PADDING-BOTTOM: 8px; WIDTH: 100%; PADDING-TOP: 8px; HEIGHT: 100%"></div><br />
</span> <br />
</SeparatorTemplate><br />
</asp:DataList><br />
</p><br />
</form><br />
</body><br />
</html><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Binding a ListBox Control to a Data Source==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language=VB Debug=true %><br />
<%@ Import Namespace="System.Data" %><br />
<%@ Import Namespace="System.Data.OLEDB" %><br />
<script runat=server><br />
Sub Page_Load(ByVal Sender as Object, ByVal E as EventArgs)<br />
If Not IsPostBack Then<br />
Dim DBConn as OleDbConnection<br />
Dim DBCommand As OleDbDataAdapter<br />
Dim DSPageData as New DataSet<br />
DBConn = New OleDbConnection( _<br />
"PROVIDER=Microsoft.Jet.OLEDB.4.0;" _<br />
& "DATA SOURCE=" _<br />
& Server.MapPath("EmployeeDatabase.mdb;"))<br />
DBCommand = New OleDbDataAdapter _<br />
("Select ID, FirstName " _<br />
& "From Employee " _<br />
& "Order By FirstName", DBConn)<br />
DBCommand.Fill(DSPageData, _<br />
"Employee")<br />
lbDepartments.DataSource = _<br />
DSPageData.Tables("Employee").DefaultView<br />
lbDepartments.DataBind()<br />
End If<br />
End Sub<br />
</SCRIPT><br />
<HTML><br />
<HEAD><br />
<TITLE>Binding a ListBox Control to a Data Source</TITLE><br />
</HEAD><br />
<Body LEFTMARGIN="40"><br />
<form runat="server"><br />
<BR><BR><br />
<asp:listbox<br />
id="lbDepartments"<br />
datatextfield="FirstName" <br />
datavaluefield="ID"<br />
rows=3<br />
runat="server"<br />
/><br />
</form><br />
</BODY><br />
</HTML><br />
<br />
</source><br />
<br />
<br />
<A href="http://www.nfex.ru/Code/ASPDownload/EmployeeDatabase.zip">EmployeeDatabase.zip( 10 k)</a></div>
Admin