http://nfex.ru/index.php?action=history&feed=atom&title=ASP.Net%2FADO.net_Database%2FFormView
ASP.Net/ADO.net Database/FormView - История изменений
2026-04-29T19:07:14Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://nfex.ru/index.php?title=ASP.Net/ADO.net_Database/FormView&diff=1686&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/FormView&diff=1687&oldid=prev
Admin: 1 версия
2010-05-26T11:51:10Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Basic FormView==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<br />
<%@ Page Language="C#" AutoEventWireup="true"%><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>Untitled Page</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<asp:SqlDataSource ID="sourceEmployees" <br />
runat="server" <br />
ConnectionString="<%$ ConnectionStrings:Northwind %>"<br />
ProviderName="System.Data.SqlClient" <br />
SelectCommand="SELECT * FROM Employees"/><br />
<asp:FormView ID="FormView1" runat="server" DataSourceID="sourceEmployees"><br />
<ItemTemplate><br />
<%# Eval("EmployeeID") %> - <br />
<%# Eval("TitleOfCourtesy") %> <%# Eval("FirstName") %><br />
<%# Eval("LastName") %><br />
<%# Eval("Address") %><br /><br />
<%# Eval("City") %>, <%# Eval("Country") %>,<br />
<%# Eval("PostalCode") %><br /><br />
<%# Eval("HomePhone") %><br />
<%# Eval("Notes") %><br />
</ItemTemplate><br />
</asp:FormView><br />
</form><br />
</body><br />
</html><br />
File: Web.config<br />
<?xml version="1.0"?><br />
<configuration xmlns="http://schemas.microsoft.ru/.NetConfiguration/v2.0"><br />
<appSettings/><br />
<connectionStrings><br />
<add name="Northwind" connectionString="Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI"/><br />
</connectionStrings><br />
</configuration><br />
</source><br />
<br />
<br />
<br />
<br />
==ItemTemplate in FormView==<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 id="Head1" runat="server"><br />
<title>Edit FormView</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div id="container"><br />
Book Details<br />
<asp:FormView ID="frmvBooks" runat="server" DataSourceID="dsBooks" <br />
AllowPaging="true" DataKeyNames="Isbn"><br />
<ItemTemplate><br />
ISBN: <br /><br />
<asp:Label ID="labIsbn" runat="server"<br />
Text="<%# Eval("ISBN") %>" /><br /><br />
Title:<br /><br />
<asp:Label ID="labTitle" runat="server"<br />
Text="<%# Eval("Title") %>" /><br /><br />
Publisher:<br /><br />
<asp:Label ID="labPublisher" runat="server"<br />
Text="<%# Eval("PublisherName") %>" /><br /><br />
Year:<br /><br />
<asp:Label ID="labYear" runat="server"<br />
Text="<%# Eval("YearPublished") %>" /><br /><br />
Description:<br /><br />
<asp:Label ID="txtDecs" runat="server"<br />
Text="<%# Eval("BriefDescription") %>" /><br/> <br />
</div><br />
</ItemTemplate><br />
<EmptyDataTemplate><br />
No book matched this ISBN<br />
</EmptyDataTemplate><br />
<br />
<br />
<PagerStyle CssClass="singleBookTitle" /><br />
<PagerSettings Mode="NextPreviousFirstLast" <br />
FirstPageImageUrl="images/page_first.gif"<br />
LastPageImageUrl="images/page_last.gif"<br />
NextPageImageUrl="images/page_next.gif"<br />
PreviousPageImageUrl="images/page_previous.gif"/><br />
</asp:FormView><br />
</div><br />
<asp:SqlDataSource ID="dsBooks" runat="server"<br />
ProviderName="System.Data.OleDb" <br />
ConnectionString="<%$ ConnectionStrings:Books %>"<br />
SelectCommand="SELECT ISBN,Title,PublisherName,Books.PublisherId,YearPublished,BriefDescription FROM Books INNER JOIN Publishers ON Books.PublisherId=Publishers.PublisherId WHERE ISBN=@isbn"><br />
<SelectParameters><br />
<asp:QueryStringParameter Name="isbn" QueryStringField="id" /><br />
</SelectParameters> <br />
<br />
</asp:SqlDataSource><br />
<br />
</form><br />
</body><br />
</html><br />
</source><br />
<br />
<br />
<br />
<br />
==Using a FormView control to display and edit data==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><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 />
<asp:FormView ID="FormView1" Runat="server" DataSourceID="SqlDataSource1"<br />
DataKeyNames="CustomerID" AllowPaging="True"><br />
<EditItemTemplate><br />
CustomerID:<br />
<asp:Label Text="<%# Eval("CustomerID") %>" Runat="server"<br />
ID="CustomerIDLabel1"><br />
</asp:Label><br /><br />
CompanyName:<br />
<asp:TextBox Text="<%# Bind("CompanyName") %>" Runat="server"<br />
ID="CompanyNameTextBox"></asp:TextBox><br /><br />
ContactName:<br />
<asp:TextBox Text="<%# Bind("ContactName") %>" Runat="server"<br />
ID="ContactNameTextBox"></asp:TextBox><br /><br />
ContactTitle:<br />
<asp:TextBox Text="<%# Bind("ContactTitle") %>" Runat="server"<br />
ID="ContactTitleTextBox"></asp:TextBox><br /><br />
Address:<br />
<asp:TextBox Text="<%# Bind("Address") %>" Runat="server"<br />
ID="AddressTextBox"></asp:TextBox><br /><br />
City:<br />
<asp:TextBox Text="<%# Bind("City") %>" Runat="server"<br />
ID="CityTextBox"></asp:TextBox><br /><br />
Region:<br />
<asp:TextBox Text="<%# Bind("Region") %>" Runat="server"<br />
ID="RegionTextBox"></asp:TextBox><br /><br />
PostalCode:<br />
<asp:TextBox Text="<%# Bind("PostalCode") %>" Runat="server"<br />
ID="PostalCodeTextBox"></asp:TextBox><br /><br />
Country:<br />
<asp:TextBox Text="<%# Bind("Country") %>" Runat="server"<br />
ID="CountryTextBox"></asp:TextBox><br /><br />
Phone:<br />
<asp:TextBox Text="<%# Bind("Phone") %>" Runat="server"<br />
ID="PhoneTextBox"></asp:TextBox><br /><br />
Fax:<br />
<asp:TextBox Text="<%# Bind("Fax") %>" Runat="server"<br />
ID="FaxTextBox"></asp:TextBox><br /><br />
<br /><br />
<asp:Button ID="Button2" Runat="server" Text="Update"<br />
CommandName="update" /><br />
<asp:Button ID="Button3" Runat="server" Text="Cancel"<br />
CommandName="cancel" /><br />
</EditItemTemplate><br />
<ItemTemplate><br />
CustomerID:<asp:Label ID="CustomerIDLabel" Runat="server"<br />
Text="<%# Bind("CustomerID") %>"><br />
</asp:Label><br />
CompanyName:<asp:Label ID="CompanyNameLabel" Runat="server"<br />
Text="<%# Bind("CompanyName") %>"><br />
</asp:Label><br />
ContactName:<asp:Label ID="ContactNameLabel" Runat="server"<br />
Text="<%# Bind("ContactName") %>"><br />
</asp:Label><br /><br />
ContactTitle:<asp:Label ID="ContactTitleLabel" Runat="server"<br />
Text="<%# Bind("ContactTitle") %>"><br />
</asp:Label><br /><br />
<asp:Label ID="AddressLabel" Runat="server"<br />
Text="<%# Bind("Address") %>"><br />
</asp:Label></td><br />
<asp:Label ID="CityLabel" Runat="server"<br />
Text="<%# Bind("City") %>"><br />
</asp:Label></td><br />
<asp:Label ID="RegionLabel" Runat="server"<br />
Text="<%# Bind("Region") %>"><br />
</asp:Label></td><br />
<asp:Label ID="PostalCodeLabel"<br />
Runat="server" <br />
Text="<%# Bind("PostalCode") %>"><br />
</asp:Label><br />
<asp:Label ID="CountryLabel" Runat="server"<br />
Text="<%# Bind("Country") %>"><br />
</asp:Label></td><br />
Phone:<asp:Label ID="PhoneLabel" Runat="server" <br />
Text="<%# Bind("Phone") %>"><br />
</asp:Label><br /><br />
Fax:<asp:Label ID="FaxLabel" Runat="server"<br />
Text="<%# Bind("Fax") %>"><br />
</asp:Label><br /><br />
<asp:Button ID="Button1" Runat="server"<br />
Text="Edit" CommandName="edit" /><br />
</ItemTemplate><br />
</asp:FormView><br />
<asp:SqlDataSource ID="SqlDataSource1" Runat="server" <br />
SelectCommand="SELECT * FROM [Customers]"<br />
ConnectionString="<%$ ConnectionStrings:AppConnectionString1 %>"><br />
</asp:SqlDataSource><br />
<br />
</div><br />
</form><br />
</body><br />
</html><br />
File: Web.config<br />
<configuration><br />
<appSettings/><br />
<connectionStrings><br />
<add name="AppConnectionString1" <br />
connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"<br />
providerName="System.Data.SqlClient" /><br />
</connectionStrings><br />
<system.web><br />
<compilation debug="true" strict="false" explicit="true"><br />
<codeSubDirectories><br />
<add directoryName="VB"></add><br />
<add directoryName="CS"></add><br />
</codeSubDirectories><br />
</compilation><br />
<pages><br />
<namespaces><br />
<clear/><br />
<add namespace="System"/><br />
<add namespace="System.Collections"/><br />
<add namespace="System.Collections.Specialized"/><br />
<add namespace="System.Configuration"/><br />
<add namespace="System.Text"/><br />
<add namespace="System.Text.RegularExpressions"/><br />
<add namespace="System.Web"/><br />
<add namespace="System.Web.Caching"/><br />
<add namespace="System.Web.SessionState"/><br />
<add namespace="System.Web.Security"/><br />
<add namespace="System.Web.Profile"/><br />
<add namespace="System.Web.UI"/><br />
<add namespace="System.Web.UI.WebControls"/><br />
<add namespace="System.Web.UI.WebControls.WebParts"/><br />
<add namespace="System.Web.UI.HtmlControls"/><br />
</namespaces><br />
</pages><br />
<authentication mode="Windows"></authentication><br />
<identity impersonate="true"/><br />
</system.web><br />
</configuration><br />
</source></div>
Admin