http://nfex.ru/index.php?action=history&feed=atom&title=ASP.Net%2FData_Binding%2FTemplateField
ASP.Net/Data Binding/TemplateField - История изменений
2026-04-30T01:41:29Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://nfex.ru/index.php?title=ASP.Net/Data_Binding/TemplateField&diff=2052&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/Data_Binding/TemplateField&diff=2053&oldid=prev
Admin: 1 версия
2010-05-26T11:52:12Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Displaying Column Summaries==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<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 />
<script runat="server"><br />
private decimal _totals = 0;<br />
protected void grdProducts_RowDataBound(object sender, GridViewRowEventArgs e)<br />
{<br />
if (e.Row.RowType == DataControlRowType.DataRow)<br />
{<br />
decimal totals = (decimal)DataBinder.Eval(e.Row.DataItem, "BoxOfficeTotals");<br />
_totals += totals;<br />
}<br />
if (e.Row.RowType == DataControlRowType.Footer)<br />
{<br />
Label lblSummary = (Label)e.Row.FindControl("lblSummary");<br />
lblSummary.Text = String.Format("Total: {0:c}", _totals);<br />
}<br />
}<br />
</script><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head id="Head1" runat="server"><br />
<title>Summary Column</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<asp:GridView<br />
id="grdProducts"<br />
DataSourceID="srcProducts"<br />
OnRowDataBound="grdProducts_RowDataBound"<br />
AutoGenerateColumns="false"<br />
ShowFooter="true"<br />
Runat="server"><br />
<Columns><br />
<asp:BoundField<br />
DataField="Title"<br />
HeaderText="Title" /><br />
<asp:TemplateField HeaderText="Box Office Totals"><br />
<ItemTemplate><br />
<%# Eval("BoxOfficeTotals", "{0:c}") %><br />
</ItemTemplate><br />
<FooterTemplate><br />
<asp:Label<br />
id="lblSummary"<br />
Runat="server" /><br />
</FooterTemplate><br />
</asp:TemplateField><br />
</Columns><br />
</asp:GridView><br />
<asp:SqlDataSource<br />
id="srcProducts"<br />
ConnectionString="<%$ ConnectionStrings:Products %>"<br />
SelectCommand="SELECT * FROM Products"<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><br />
</source><br />
<br />
<br />
<br />
<br />
==Displaying Nested Master/Details Forms==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<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 />
<script runat="server"><br />
protected void grdProductCategories_RowDataBound(object sender, GridViewRowEventArgs e)<br />
{<br />
if (e.Row.RowType == DataControlRowType.DataRow)<br />
{<br />
int categoryId = (int)DataBinder.Eval(e.Row.DataItem,"Id");<br />
SqlDataSource srcProducts = (SqlDataSource)e.Row.FindControl("srcProducts");<br />
srcProducts.SelectParameters["CategoryId"].DefaultValue = categoryId.ToString();<br />
}<br />
}<br />
</script><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<asp:GridView<br />
id="grdProducts"<br />
DataSourceID="srcProductCategories"<br />
OnRowDataBound="grdProductCategories_RowDataBound"<br />
AutoGenerateColumns="false"<br />
CssClass="categories"<br />
ShowHeader="false"<br />
GridLines="none"<br />
Runat="server"><br />
<Columns><br />
<asp:TemplateField><br />
<ItemTemplate><br />
<h1><%# Eval("Name") %></h1><br />
<asp:GridView<br />
id="grdProducts"<br />
DataSourceId="srcProducts"<br />
CssClass="Products"<br />
GridLines="none"<br />
Runat="server" /><br />
<asp:SqlDataSource<br />
id="srcProducts"<br />
ConnectionString="<%$ ConnectionStrings:Products %>"<br />
SelectCommand="SELECT Title,Director FROM Products<br />
WHERE CategoryId=@CategoryId"<br />
Runat="server"><br />
<SelectParameters><br />
<asp:Parameter Name="CategoryId" /><br />
</SelectParameters><br />
</asp:SqlDataSource><br />
</ItemTemplate><br />
</asp:TemplateField><br />
</Columns><br />
</asp:GridView><br />
<asp:SqlDataSource<br />
id="srcProductCategories"<br />
ConnectionString="<%$ ConnectionStrings:Products %>"<br />
SelectCommand="SELECT Id,Name FROM ProductCategories"<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><br />
</source><br />
<br />
<br />
<br />
<br />
==Editing Data using Templated Columns==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" %><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head runat="server"><br />
<title>Editing Data using Templated Columns</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<asp:SqlDataSource ID="productsSource" runat="server"<br />
ProviderName="System.Data.SqlClient" <br />
ConnectionString="<%$ ConnectionStrings:AdventureWorks %>"<br />
SelectCommand="Select ProductID, Name, ProductNumber, DaysToManufacture, SellStartDate, ReorderPoint from Production.Product" <br />
UpdateCommand="Update Production.Product Set ReorderPoint = @ReorderPoint Where ProductID = @ProductID"> <br />
</asp:SqlDataSource><br />
<asp:GridView ID="gridProducts" runat="server" DataSourceID="productsSource"<br />
AutoGenerateColumns="False" DataKeyNames="ProductID"> <br />
<Columns><br />
<asp:CommandField ShowEditButton="true" /><br />
<asp:TemplateField HeaderText="Products"><br />
<ItemTemplate> <br />
<%# Eval("ProductID") %> -<br />
<%# Eval("Name") %> <br />
Product Number: <%# Eval("ProductNumber") %><br /> <br />
Reorder Point:<%# Eval("ReorderPoint") %><br /><br />
</small><br />
</ItemTemplate><br />
<EditItemTemplate><br />
<%# Eval("ProductID") %> -<br />
<%# Eval("Name") %> <br />
Product Number: <%# Eval("ProductNumber") %><br /> <br />
Reorder Point:<asp:TextBox Text="<%# Bind("ReorderPoint") %>" runat="server" id="textBox"/><br />
</small><br />
</EditItemTemplate><br />
</asp:TemplateField> <br />
</Columns><br />
</asp:GridView><br />
</div><br />
</form><br />
</body><br />
</html><br />
</source><br />
<br />
<br />
<br />
<br />
==GridView with Template and backend code==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<br />
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="GridViewTemplates2" %><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 />
<div><br />
<asp:SqlDataSource ID="sourceProducts" <br />
runat="server" <br />
ConnectionString="<%$ ConnectionStrings:Northwind %>"<br />
ProviderName="System.Data.SqlClient" <br />
SelectCommand="SELECT ProductID, ProductName, UnitPrice, UnitsInStock FROM Products"><br />
</asp:SqlDataSource><br />
<asp:GridView ID="GridView1" <br />
runat="server" <br />
AutoGenerateColumns="False" <br />
CellPadding="4"<br />
DataKeyNames="ProductID" <br />
DataSourceID="sourceProducts" <br />
Font-Names="Verdana" <br />
Font-Size="Small" <br />
ForeColor="#333333" <br />
GridLines="None" <br />
AllowPaging="True" <br />
OnRowCommand="GridView1_RowCommand"><br />
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /><br />
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" /><br />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" /><br />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" /><br />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /><br />
<AlternatingRowStyle BackColor="White" /><br />
<Columns><br />
<asp:TemplateField HeaderText="Status"><br />
<ItemTemplate><br />
<asp:ImageButton ID="ImageButton1" runat="server" <br />
ImageUrl="<%# GetStatusPicture(Container.DataItem) %>"<br />
CommandName="StatusClick"<br />
CommandArgument="<%# Eval("ProductID") %>"<br />
/></ItemTemplate><br />
</asp:TemplateField><br />
<asp:BoundField DataField="ProductID" <br />
HeaderText="ID" <br />
InsertVisible="False" <br />
ReadOnly="True"<br />
SortExpression="ProductID" /><br />
<asp:BoundField DataField="ProductName" <br />
HeaderText="Product" <br />
SortExpression="ProductName" /><br />
<asp:BoundField DataField="UnitPrice" <br />
DataFormatString="{0:C}" <br />
HeaderText="Price"<br />
SortExpression="UnitPrice" /><br />
<asp:BoundField DataField="UnitsInStock" <br />
HeaderText="UnitsInStock" <br />
SortExpression="Units In Stock" /><br />
</Columns><br />
</asp:GridView><br />
<br /><br />
<asp:Label ID="lblInfo" runat="server" Font-Names="Verdana" Font-Size="Small"></asp:Label><br />
<br />
</div><br />
</form><br />
</body><br />
</html><br />
File: Default.aspx.cs<br />
using System;<br />
using System.Data;<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 />
using System.Web.UI.WebControls.WebParts;<br />
using System.Web.UI.HtmlControls;<br />
public partial class GridViewTemplates2 : System.Web.UI.Page<br />
{<br />
protected string GetStatusPicture(object dataItem)<br />
{<br />
int units = Int32.Parse(DataBinder.Eval(dataItem, "UnitsInStock").ToString());<br />
if (units == 0)<br />
{<br />
return "0.gif";<br />
}<br />
else if (units > 50)<br />
{<br />
return "50.gif";<br />
}<br />
else<br />
{<br />
return "blank.gif";<br />
}<br />
}<br />
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)<br />
{<br />
if (e.rumandName == "StatusClick")<br />
lblInfo.Text = "You clicked product #" + e.rumandArgument;<br />
}<br />
<br />
}<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 />
==Master-Detail GridView in Single Page==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<br />
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="MasterDetailsSinglePage" %><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 />
<div><br />
<asp:GridView id="gridMaster" <br />
runat="server" <br />
GridLines="None" <br />
AutoGenerateColumns="False" <br />
DataKeyNames="CategoryID" <br />
DataSourceID="sourceCategories" <br />
OnRowDataBound="gridMaster_RowDataBound"><br />
<AlternatingRowStyle BackColor="PaleGoldenrod"></AlternatingRowStyle><br />
<HeaderStyle Font-Bold="True" BackColor="Tan"></HeaderStyle><br />
<FooterStyle BackColor="Tan"></FooterStyle><br />
<Columns><br />
<asp:TemplateField HeaderText="Category"><br />
<ItemStyle VerticalAlign="Top" Width="20%"></ItemStyle><br />
<ItemTemplate><br />
<br><b><%# Eval("CategoryName") %></b><br><br />
<br><%# Eval("Description" ) %><br><br />
</ItemTemplate><br />
</asp:TemplateField><br />
<asp:TemplateField HeaderText="Products"><br />
<ItemStyle VerticalAlign="Top"></ItemStyle><br />
<ItemTemplate><br />
<asp:GridView id="DataGrid2" <br />
runat="server" <br />
AutoGenerateColumns="False"<br />
BorderStyle="None"><br />
<RowStyle ForeColor="#330099" BackColor="White"></RowStyle><br />
<HeaderStyle Font-Bold="True" ForeColor="#FFFFCC" BackColor="#990000"></HeaderStyle><br />
<Columns><br />
<asp:BoundField DataField="ProductName" HeaderText="Product Name"><br />
<ItemStyle Width="250px" /><br />
</asp:BoundField><br />
<asp:BoundField DataField="UnitPrice" HeaderText="Unit Price" DataFormatString="{0:C}" /><br />
</Columns> <br />
</asp:GridView><br />
</ItemTemplate><br />
</asp:TemplateField><br />
</Columns><br />
<PagerStyle HorizontalAlign="Center" ForeColor="DarkSlateBlue" BackColor="PaleGoldenrod"></PagerStyle><br />
</asp:GridView><br />
<asp:SqlDataSource ID="sourceCategories" <br />
runat="server" <br />
ConnectionString="<%$ ConnectionStrings:Northwind %>"<br />
ProviderName="System.Data.SqlClient" <br />
SelectCommand="SELECT * FROM Categories"/><br />
<asp:SqlDataSource ID="sourceProducts" <br />
runat="server" <br />
ConnectionString="<%$ ConnectionStrings:Northwind %>"<br />
ProviderName="System.Data.SqlClient" <br />
SelectCommand="SELECT * FROM Products WHERE CategoryID=@CategoryID"><br />
<SelectParameters><br />
<asp:Parameter Name="CategoryID" Type="Int32" /><br />
</SelectParameters><br />
</asp:SqlDataSource><br />
</div><br />
</form><br />
</body><br />
</html><br />
File: Default.aspx.cs<br />
using System;<br />
using System.Data;<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 />
using System.Web.UI.WebControls.WebParts;<br />
using System.Web.UI.HtmlControls;<br />
public partial class MasterDetailsSinglePage : System.Web.UI.Page<br />
{<br />
protected void gridMaster_RowDataBound(object sender, GridViewRowEventArgs e)<br />
{<br />
if (e.Row.RowType == DataControlRowType.DataRow)<br />
{<br />
GridView gridChild = (GridView)e.Row.Cells[1].Controls[1];<br />
sourceProducts.SelectParameters[0].DefaultValue = gridMaster.DataKeys[e.Row.DataItemIndex].Value.ToString();<br />
object data = sourceProducts.Select(DataSourceSelectArguments.Empty);<br />
<br />
gridChild.DataSource = data;<br />
gridChild.DataBind();<br />
}<br />
}<br />
}<br />
</source><br />
<br />
<br />
<br />
<br />
==Using Templated Columns with GridView==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" %><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head runat="server"><br />
<title>Using Templated Columns with GridView</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<asp:SqlDataSource ID="productsSource" runat="server"<br />
ProviderName="System.Data.SqlClient" <br />
ConnectionString="<%$ ConnectionStrings:AdventureWorks %>"<br />
SelectCommand="Select ProductID, Name, ProductNumber, DaysToManufacture, SellStartDate, ReorderPoint from Production.Product"> <br />
</asp:SqlDataSource><br />
<asp:GridView ID="gridProducts" runat="server" DataSourceID="productsSource"<br />
AutoGenerateColumns="False"> <br />
<Columns><br />
<asp:TemplateField HeaderText="Products"><br />
<ItemTemplate><br />
<%# Eval("ProductID") %> -<br />
<%# Eval("Name") %> <br />
Product Number: <%# Eval("ProductNumber") %><br /><br />
Days to manufacture:<%# Eval("DaysToManufacture") %> <br /><br />
Start Date: <%# Eval("SellStartDate", "{0:MM/dd/yy}") %><br /> <br />
Reorder Point:<%# Eval("ReorderPoint") %><br />
</ItemTemplate><br />
</asp:TemplateField> <br />
</Columns><br />
</asp:GridView><br />
</div><br />
</form><br />
</body><br />
</html><br />
</source></div>
Admin