利用ASP.NET DataGrid显示主次关系的数据

技术2022-05-11 44

&lt;%@ Page Language=&quot;C#&quot; AutoEventWireup=&quot;true&quot; CodeFile=&quot;Default.aspx.cs&quot; Inherits=&quot;_Test_Default&quot; %&gt; &lt;!DOCTYPE html PUBLIC &quot;-//W3C//DTD XHTML 1.0 Transitional//EN&quot; &quot;http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd&quot;&gt; &lt;html xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&gt; &lt;head runat=&quot;server&quot;&gt; &lt;title&gt;无标题页&lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;form runat=&quot;server&quot;&gt; &lt;asp:DataGrid ID=&quot;DataGrid1&quot; BorderColor=&quot;#0099FF&quot; runat=&quot;server&quot; ShowHeader=&quot;False&quot; Width=&quot;470px&quot; CellPadding=&quot;0&quot; CellSpacing=&quot;0&quot; AutoGenerateColumns=&quot;False&quot; BorderWidth=&quot;2px&quot; OnItemDataBound=&quot;DataGrid1_ItemDataBound&quot;&gt; &lt;Columns&gt; &lt;asp:TemplateColumn&gt; &lt;ItemTemplate&gt; &lt;table cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; width=&quot;100%&quot; border=&quot;0&quot;&gt; &lt;tr&gt; &lt;td bgcolor=&quot;#FF6600&quot;&gt; &lt;b&gt;订单号： &lt;%# Eval(&quot;OrderID&quot;) %&gt; &lt;/b&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align=&quot;right&quot;&gt; &lt;asp:DataGrid ID=&quot;DataGrid2&quot; runat=&quot;server&quot; AutoGenerateColumns=&quot;False&quot; BorderColor=&quot;#33FF33&quot; DataKeyField=&quot;OrderID&quot; DataSource='&lt;%# ((System.Data.DataRowView)Container.DataItem).CreateChildView(&quot;OrderRelation&quot;) %&gt;'&gt; &lt;HeaderStyle Font-Bold=&quot;True&quot; ForeColor=&quot;#CC0066&quot; BackColor=&quot;#FFCCFF&quot;&gt;&lt;/HeaderStyle&gt; &lt;Columns&gt; &lt;asp:BoundColumn Visible=&quot;False&quot; DataField=&quot;OrderID&quot; ReadOnly=&quot;True&quot;&gt;&lt;/asp:BoundColumn&gt; &lt;asp:TemplateColumn HeaderText=&quot;产品名称&quot;&gt; &lt;HeaderStyle Width=&quot;300px&quot;&gt;&lt;/HeaderStyle&gt; &lt;ItemTemplate&gt; &lt;%# Eval(&quot;ProductName&quot;) %&gt; &lt;/ItemTemplate&gt; &lt;/asp:TemplateColumn&gt; &lt;asp:BoundColumn DataField=&quot;UnitPrice&quot; HeaderText=&quot;单价&quot;&gt;&lt;/asp:BoundColumn&gt; &lt;asp:BoundColumn DataField=&quot;Quantity&quot; HeaderText=&quot;数量&quot;&gt;&lt;/asp:BoundColumn&gt; &lt;asp:BoundColumn DataField=&quot;Discount&quot; HeaderText=&quot;折扣&quot;&gt;&lt;/asp:BoundColumn&gt; &lt;/Columns&gt; &lt;/asp:DataGrid&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/ItemTemplate&gt; &lt;/asp:TemplateColumn&gt; &lt;/Columns&gt; &lt;/asp:DataGrid&gt; &lt;/form&gt; &lt;/body&gt; &lt;/html&gt; using System; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; public partial class _Test_Default : System.Web.UI.Page { protected void Page_Load( object sender, EventArgs e ) { SqlConnection OrdersConnection = new SqlConnection(@&quot;User ID=sa;Password=;Initial Catalog=NorthWind;Server=(local)&quot;); SqlDataAdapter OrderAdapter = new SqlDataAdapter(&quot;Select * from Orders; select OrderID ,Products.ProductName, [order Details].Unitprice,[order Details].Quantity,[order Details].discount from [order Details],Products where [Order Details].ProductId=Products.ProductID&quot;, OrdersConnection); DataSet OrderDataSet = new DataSet(); OrderAdapter.Fill(OrderDataSet); OrderDataSet.Tables[0].TableName = &quot;Orders&quot;; OrderDataSet.Tables[1].TableName = &quot;Order Details&quot;; DataColumn Parent = OrderDataSet.Tables[&quot;Orders&quot;].Columns[&quot;OrderID&quot;]; DataColumn Child = OrderDataSet.Tables[&quot;Order Details&quot;].Columns[&quot;OrderID&quot;]; DataRelation OrderRelation = new DataRelation(&quot;OrderRelation&quot;, Parent, Child, false); OrderDataSet.Relations.Add(OrderRelation); DataGrid1.DataSource = OrderDataSet.Tables[&quot;Orders&quot;].DefaultView; DataBind(); } protected void DataGrid1_ItemDataBound( object sender, DataGridItemEventArgs e ) { e.Item.Cells[0].BackColor = System.Drawing.Color.Ivory; } }

专利

最新回复(0)