http://nfex.ru/index.php?action=history&feed=atom&title=ASP.NET_Tutorial%2FData_Binding%2FDataList
ASP.NET Tutorial/Data Binding/DataList - История изменений
2026-04-30T01:03:49Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://nfex.ru/index.php?title=ASP.NET_Tutorial/Data_Binding/DataList&diff=3137&oldid=prev
в 15:30, 26 мая 2010
2010-05-26T15:30:57Z
<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_Tutorial/Data_Binding/DataList&diff=3138&oldid=prev
Admin: 1 версия
2010-05-26T11:58:05Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== A DataList control that contains a template that includes two DataBinding expressions.==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" %><br />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"<br />
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head id="Head1" runat="server"><br />
<title>Show DataList</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<asp:DataList<br />
id="DataList1"<br />
DataSourceId="srcProducts"<br />
Runat="server"><br />
<ItemTemplate><br />
<b>Product Title:</b><br />
<%#Eval("Title")%><br />
<br /><br />
<b>Date Released:</b><br />
<%#Eval("DateReleased", "{0:D}") %><br />
<hr /><br />
</ItemTemplate><br />
</asp:DataList><br />
<asp:SqlDataSource<br />
id="srcProducts"<br />
ConnectionString="Data Source=.\SQLExpress;<br />
AttachDbFilename=|DataDirectory|MyDatabase.mdf;<br />
Integrated Security=True;User Instance=True"<br />
SelectCommand="SELECT Title,Director,DateReleased FROM Products"<br />
Runat="server" /><br />
</div><br />
</form><br />
</body><br />
</html></source><br />
<br />
<br />
<br />
== Get an flexible and feature-rich UI using the DataList control==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" <br />
Inherits="Default" %><br />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head runat="server"><br />
<title>DataList in action</title><br />
</head><br />
<body><br />
<div id="pageContent"><br />
<form id="form1" runat="server"><br />
<asp:DropDownList ID="Countries" runat="server" <br />
AutoPostBack="true" <br />
AppendDataBoundItems="True" <br />
OnSelectedIndexChanged="Countries_SelectedIndexChanged"><br />
<asp:ListItem>[No country]</asp:ListItem><br />
</asp:DropDownList><br />
<br />
<asp:DataList ID="DataList1" runat="server" RepeatColumns="5" GridLines="Both"><br />
<FooterStyle Font-Bold="true" ForeColor="blue" /><br />
<HeaderTemplate><br />
<h2>We have customers in the following cities</h2><br />
</HeaderTemplate> <br />
<ItemTemplate><br />
<%# Eval("City") %> &nbsp;&nbsp;<b><%# Eval("Country")%></b><br />
</ItemTemplate><br />
<FooterTemplate><br />
<%# CalcTotal() %> cities<br />
</FooterTemplate><br />
</asp:DataList><br />
</form><br />
</div><br />
</body><br />
</html><br />
File: Default.aspx.cs<br />
using System;<br />
using System.Data;<br />
using System.Data.SqlClient;<br />
using System.Configuration;<br />
using System.Collections;<br />
using System.Web;<br />
using System.Web.Security;<br />
using System.Web.UI;<br />
using System.Web.UI.WebControls;<br />
<br />
public partial class Default : System.Web.UI.Page<br />
{<br />
DataTable data;<br />
protected void Page_Load(object sender, EventArgs e)<br />
{<br />
if (!IsPostBack)<br />
{<br />
FillCountries();<br />
}<br />
}<br />
protected void FillCountries()<br />
{<br />
string connString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;<br />
string cmdText = "SELECT DISTINCT country FROM customers;";<br />
data = new DataTable();<br />
SqlDataAdapter adapter = new SqlDataAdapter(cmdText, connString);<br />
adapter.Fill(data);<br />
Countries.DataSource = data;<br />
Countries.DataTextField = "country";<br />
Countries.DataBind();<br />
}<br />
protected int CalcTotal()<br />
{<br />
return data.Rows.Count;<br />
}<br />
protected void Countries_SelectedIndexChanged(object sender, EventArgs e)<br />
{<br />
string connString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;<br />
string cmdText = "SELECT DISTINCT country, city FROM customers WHERE country=@TheCountry";<br />
data = new DataTable();<br />
SqlDataAdapter adapter = new SqlDataAdapter(cmdText, connString);<br />
adapter.SelectCommand.Parameters.AddWithValue("@TheCountry", Countries.SelectedValue);<br />
adapter.Fill(data);<br />
DataList1.DataSource = data;<br />
DataList1.DataBind();<br />
}<br />
}</source><br />
<br />
<br />
<br />
== Nested data bind sample==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#"%><br />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head runat="server"><br />
<title>Untitled Page</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<h2>Nested data bind sample</h2><br />
<asp:DataList ID="_outerDataList" runat="server" <br />
DataSourceID="_bookstoreDataSource"><br />
<ItemTemplate><br />
Title: <%# Eval("Title") %><br /><br />
<asp:DataList runat="server" ID="_nestedDastaList"<br />
DataSource="<%# XPathSelect("chapter") %>"><br />
<ItemTemplate><br />
<h4>Chapternum: <%# XPath("@num") %></h4><br />
<h4>Chapter name: <%# XPath("@name") %></h4><br />
<%# XPath(".") %><br />
<br /><br />
</ItemTemplate><br />
</asp:DataList><br />
<br /><br />
</ItemTemplate><br />
</asp:DataList><br />
<asp:XmlDataSource ID="_bookstoreDataSource" <br />
runat="server" DataFile="~/App_Data/Data.xml"<br />
XPath="/Data/genre/book" /><br />
<br />
<br />
</div><br />
</form><br />
</body><br />
</html><br />
File: Data.xml<br />
<Data><br />
<genre name="Business"><br />
<book ISBN="1" Title="Database" Price="19.99"><br />
<chapter num="1" name="Introduction"><br />
Abstract...<br />
</chapter><br />
<chapter num="2" name="Body"><br />
Abstract...<br />
</chapter><br />
<chapter num="3" name="Conclusion"><br />
Abstract...<br />
</chapter><br />
</book><br />
<book ISBN="2" Title="Computer" Price="2.99"><br />
<chapter num="1" name="Introduction"><br />
Abstract...<br />
</chapter><br />
<chapter num="2" name="Body"><br />
Abstract...<br />
</chapter><br />
<chapter num="3" name="Conclusion"><br />
Abstract...<br />
</chapter><br />
</book><br />
<book ISBN="3" Title="VB" Price="19.99"><br />
<chapter num="1" name="Introduction"><br />
Abstract...<br />
</chapter><br />
<chapter num="2" name="Body"><br />
Abstract...<br />
</chapter><br />
<chapter num="3" name="Conclusion"><br />
Abstract...<br />
</chapter><br />
</book><br />
</genre><br />
</Data></source></div>
Admin