http://nfex.ru/index.php?action=history&feed=atom&title=ASP.NET_Tutorial%2FData_Binding%2FFormView
ASP.NET Tutorial/Data Binding/FormView - История изменений
2026-04-29T21:11:23Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://nfex.ru/index.php?title=ASP.NET_Tutorial/Data_Binding/FormView&diff=3170&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/FormView&diff=3171&oldid=prev
Admin: 1 версия
2010-05-26T11:59:56Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== A FormView: edit a table record in the database table==<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 FormView</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<asp:FormView<br />
id="FormView1"<br />
DataKeyNames="Id"<br />
DataSourceId="srcProducts"<br />
DefaultMode="Edit"<br />
AllowPaging="true"<br />
Runat="server"><br />
<EditItemTemplate><br />
<asp:Label<br />
id="lblTitle"<br />
Text="Title:"<br />
AssociatedControlID="txtTitle"<br />
Runat="server" /><br />
<asp:TextBox<br />
id="txtTitle"<br />
Text="<%#Bind("Title")%>"<br />
Runat="server" /><br />
<br /><br />
<asp:Label<br />
id="lblDirector"<br />
Text="Director:"<br />
AssociatedControlID="txtDirector"<br />
Runat="server" /><br />
<asp:TextBox<br />
id="txtDirector"<br />
Text="<%#Bind("Director")%>"<br />
Runat="server" /><br />
<br /><br />
<asp:Button<br />
id="btnUpdate"<br />
Text="Update"<br />
CommandName="Update"<br />
Runat="server" /><br />
</EditItemTemplate><br />
</asp:FormView><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 Id, Title,Director,DateReleased FROM Products"<br />
UpdateCommand="UPDATE Products SET Title=@Title,<br />
Director=@Director WHERE Id=@Id"<br />
Runat="server" /><br />
<br />
</div><br />
</form><br />
</body><br />
</html></source><br />
<br />
<br />
<br />
== Deleting Data with the FormView Control==<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 />
<body><br />
<form id="form1" runat="server"><br />
<div id="content"><br />
<asp:FormView<br />
id="frmProducts"<br />
DataSourceID="srcProducts"<br />
DataKeyNames="Id"<br />
AllowPaging="true"<br />
Runat="server"><br />
<ItemTemplate><br />
<h1><%# Eval("Title") %></h1><br />
<b>Directed By:</b><br />
<%# Eval("Director") %><br />
<br /><br />
<b>In Theaters:</b><br />
<%#Eval("InStock") %><br />
<hr /><br />
<asp:LinkButton<br />
id="lnkDelete"<br />
Text="Delete Product"<br />
CommandName="Delete"<br />
OnClientClick="return confirm("Are you sure?");"<br />
Runat="server" /><br />
</ItemTemplate><br />
</asp:FormView><br />
<asp:SqlDataSource<br />
id="srcProducts"<br />
ConnectionString="<%$ ConnectionStrings:Products %>"<br />
SelectCommand="SELECT Id,Title,Director,InStock<br />
FROM Products"<br />
DeleteCommand="DELETE Products WHERE Id=@Id"<br />
Runat="server" /><br />
</div><br />
</form><br />
</body><br />
</html><br />
File: Web.config<br />
<configuration><br />
<connectionStrings><br />
<add name="Products" <br />
connectionString="Data Source=.\SQLEXPRESS;<br />
AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;User Instance=True" /><br />
</connectionStrings><br />
</configuration></source><br />
<br />
<br />
<br />
== Displaying Data with the FormView Control==<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 />
<body><br />
<form id="form1" runat="server"><br />
<div id="content"><br />
<asp:FormView<br />
id="frmProducts"<br />
DataSourceID="srcProducts"<br />
Runat="server"><br />
<ItemTemplate><br />
<h1><%# Eval("Title") %></h1><br />
<b>Directed By:</b><br />
<%# Eval("Director") %><br />
<br /><br />
<b>Box Office Totals:</b><br />
<%#Eval("Totals", "{0:c}") %><br />
</ItemTemplate><br />
</asp:FormView><br />
<asp:SqlDataSource<br />
id="srcProducts"<br />
ConnectionString="<%$ ConnectionStrings:Products %>"<br />
SelectCommand="SELECT Id,Title,Director,Totals FROM Products<br />
WHERE Id=1"<br />
Runat="server" /><br />
</div><br />
</form><br />
</body><br />
</html><br />
File: Web.config<br />
<configuration><br />
<connectionStrings><br />
<add name="Products" <br />
connectionString="Data Source=.\SQLEXPRESS;<br />
AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;User Instance=True" /><br />
</connectionStrings><br />
</configuration></source><br />
<br />
<br />
<br />
== Editing Data with the FormView Control==<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 />
<body><br />
<form id="form1" runat="server"><br />
<div id="content"><br />
<asp:FormView<br />
id="frmProducts"<br />
DataSourceID="srcProducts"<br />
DataKeyNames="Id"<br />
AllowPaging="true"<br />
Runat="server"><br />
<ItemTemplate><br />
<h1><%# Eval("Title") %></h1><br />
<b>Directed By:</b><br />
<%# Eval("Director") %><br />
<br /><br />
<b>Box Office Totals:</b><br />
<%#Eval("Totals", "{0:c}") %><br />
<hr /><br />
<asp:LinkButton<br />
id="lnkEdit"<br />
Text="Edit Product"<br />
CommandName="Edit"<br />
Runat="server" /><br />
</ItemTemplate><br />
<EditItemTemplate><br />
<asp:Label<br />
id="lblTitle"<br />
Text="Product Title:"<br />
AssociatedControlID="txtTitle"<br />
Runat="server" /><br />
<br /><br />
<asp:TextBox<br />
id="txtTitle"<br />
Text="<%# Bind("Title") %><br />
Runat="server" /><br />
<br /><br /><br />
<asp:Label<br />
id="lblDirector"<br />
Text="Product Director:"<br />
AssociatedControlID="txtDirector"<br />
Runat="server" /><br />
<br /><br />
<asp:TextBox<br />
id="txtDirector"<br />
Text="<%# Bind("Director") %><br />
Runat="server" /><br />
<br /><br /><br />
<asp:Label<br />
id="lblTotals"<br />
Text="Box Office Totals:"<br />
AssociatedControlID="txtTotals"<br />
Runat="server" /><br />
<br /><br />
<asp:TextBox<br />
id="txtTotals"<br />
Text="<%# Bind("Totals") %><br />
Runat="server" /><br />
<br /><br /><br />
<asp:LinkButton<br />
id="lnkUpdate"<br />
Text="Update Product"<br />
CommandName="Update"<br />
Runat="server" /><br />
|<br />
<asp:LinkButton<br />
id="lnkCancel"<br />
Text="Cancel Update"<br />
CommandName="Cancel"<br />
Runat="server" /><br />
</EditItemTemplate><br />
</asp:FormView><br />
<asp:SqlDataSource<br />
id="srcProducts"<br />
ConnectionString="<%$ ConnectionStrings:Products %>"<br />
SelectCommand="SELECT Id,Title,Director,Totals<br />
FROM Products"<br />
UpdateCommand="UPDATE Products SET Title=@Title,<br />
Director=@Director,Totals=@Totals<br />
WHERE Id=@Id"<br />
Runat="server" /><br />
</div><br />
</form><br />
</body><br />
</html></source><br />
<br />
<br />
<br />
== Inserting Data with the FormView Control==<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 />
<body><br />
<form id="form1" runat="server"><br />
<div id="content"><br />
<asp:FormView<br />
id="frmProducts"<br />
DataSourceID="srcProducts"<br />
AllowPaging="true"<br />
Runat="server"><br />
<ItemTemplate><br />
<h1><%# Eval("Title") %></h1><br />
<b>Directed By:</b><br />
<%# Eval("Director") %><br />
<br /><br />
<b>In Theaters:</b><br />
<%#Eval("InStock") %><br />
<hr /><br />
<asp:LinkButton<br />
id="lnkNew"<br />
Text="New Product"<br />
CommandName="New"<br />
Runat="server" /><br />
</ItemTemplate><br />
<InsertItemTemplate><br />
<asp:Label<br />
id="lblTitle"<br />
Text="Product Title:"<br />
AssociatedControlID="txtTitle"<br />
Runat="server" /><br />
<br /><br />
<asp:TextBox<br />
id="txtTitle"<br />
Text="<%# Bind("Title") %><br />
Runat="server" /><br />
<br /><br /><br />
<asp:Label<br />
id="lblDirector"<br />
Text="Product Director:"<br />
AssociatedControlID="txtDirector"<br />
Runat="server" /><br />
<br /><br />
<asp:TextBox<br />
id="txtDirector"<br />
Text="<%# Bind("Director") %><br />
Runat="server" /><br />
<br /><br /><br />
<asp:CheckBox<br />
id="chkInStock"<br />
Text="In Theaters"<br />
Checked="<%# Bind("InStock") %><br />
Runat="server" /><br />
<br /><br /><br />
<asp:LinkButton<br />
id="lnkInsert"<br />
Text="Insert Product"<br />
CommandName="Insert"<br />
Runat="server" /><br />
|<br />
<asp:LinkButton<br />
id="lnkCancel"<br />
Text="Cancel Insert"<br />
CommandName="Cancel"<br />
Runat="server" /><br />
</InsertItemTemplate><br />
</asp:FormView><br />
<asp:SqlDataSource<br />
id="srcProducts"<br />
ConnectionString="<%$ ConnectionStrings:Products %>"<br />
SelectCommand="SELECT Id,Title,Director,InStock<br />
FROM Products"<br />
InsertCommand="INSERT Products (Title,Director,InStock)<br />
VALUES (@Title,@Director,<br />
Runat="server" /><br />
</div><br />
</form><br />
</body><br />
</html><br />
<br />
File: Web.config<br />
<configuration><br />
<connectionStrings><br />
<add name="Products" <br />
connectionString="Data Source=.\SQLEXPRESS;<br />
AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;User Instance=True" /><br />
</connectionStrings><br />
</configuration></source><br />
<br />
<br />
<br />
== Paging Through Data with the FormView Control==<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 FormView Paging</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div id="content"><br />
<asp:FormView<br />
id="frmProducts"<br />
DataSourceID="srcProducts"<br />
AllowPaging="true"<br />
Runat="server"><br />
<ItemTemplate><br />
<h1><%# Eval("Title") %></h1><br />
<b>Directed By:</b><br />
<%# Eval("Director") %><br />
<br /><br />
<b>Box Office Totals:</b><br />
<%#Eval("Totals", "{0:c}") %><br />
</ItemTemplate><br />
</asp:FormView><br />
<asp:SqlDataSource<br />
id="srcProducts"<br />
ConnectionString="<%$ ConnectionStrings:Products %>"<br />
SelectCommand="SELECT Id,Title,Director,Totals FROM Products"<br />
Runat="server" /><br />
</div><br />
</form><br />
</body><br />
</html><br />
File: Web.config<br />
<configuration><br />
<connectionStrings><br />
<add name="Products" <br />
connectionString="Data Source=.\SQLEXPRESS;<br />
AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;User Instance=True" /><br />
</connectionStrings><br />
</configuration></source><br />
<br />
<br />
<br />
== Using a PagerTemplate with the FormView control.==<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 />
<body><br />
<form id="form1" runat="server"><br />
<div id="content"><br />
<asp:FormView<br />
id="frmProducts"<br />
DataSourceID="srcProducts"<br />
AllowPaging="true"<br />
CssClass="frmProducts"<br />
Runat="server"><br />
<ItemTemplate><br />
<h1><%# Eval("Title") %></h1><br />
<b>Directed By:</b><br />
<%# Eval("Director") %><br />
<br /><br />
<b>Box Office Totals:</b><br />
<%#Eval("Totals", "{0:c}") %><br />
</ItemTemplate><br />
<PagerTemplate><br />
<hr /><br />
<div style="float:left"><br />
Page: <%# frmProducts.PageIndex + 1 %><br />
</div><br />
<div style="float:right;white-space:nowrap"><br />
<asp:LinkButton<br />
id="lnkPrevious"<br />
Text="Previous Page"<br />
CommandName="Page"<br />
CommandArgument="Prev"<br />
Runat="server" /><br />
|<br />
<asp:LinkButton<br />
id="lnkNext"<br />
Text="Next Page"<br />
CommandName="Page"<br />
CommandArgument="Next"<br />
Runat="server" /><br />
</div><br />
</PagerTemplate><br />
</asp:FormView><br />
<asp:SqlDataSource<br />
id="srcProducts"<br />
ConnectionString="<%$ ConnectionStrings:Products %>"<br />
SelectCommand="SELECT Id,Title,Director,Totals FROM Products"<br />
Runat="server" /><br />
</div><br />
</form><br />
</body><br />
</html><br />
File: Web.config<br />
<configuration><br />
<connectionStrings><br />
<add name="Products" <br />
connectionString="Data Source=.\SQLEXPRESS;<br />
AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;User Instance=True" /><br />
</connectionStrings><br />
</configuration></source></div>
Admin