利用Repeater控件显示主－从关系数据表_repeater 主表明细表-优快云博客

NestedRepeater.aspx

&lt;%@ Import Namespace=&quot;System.Data&quot; %&gt;
&lt;%@ Page language=&quot;c#&quot; Codebehind=&quot;NestedRepeater.aspx.cs&quot;
AutoEventWireup=&quot;false&quot; Inherits=&quot;eMeng.NestedRepeater&quot; %&gt;
&lt;HTML&gt;
&lt;body&gt;
&lt;form runat=&quot;server&quot;&gt;
&lt;!-- 父Repeater开始 --&gt;
&lt;asp:repeater id=&quot;parentRepeater&quot; runat=&quot;server&quot;&gt;
&lt;itemtemplate&gt;
&lt;b&gt;
&lt;%# DataBinder.Eval(Container.DataItem,&quot;au_id&quot;) %&gt;
&lt;/b&gt;
&lt;br&gt;
&lt;!-- 子Repeater开始 --&gt;
&lt;asp:repeater id=&quot;childRepeater&quot; runat=&quot;server&quot;
datasource='&lt;%# ((DataRowView)Container.DataItem).Row.GetChildRows(&quot;myrelation&quot;) %&gt;'&gt;
&lt;itemtemplate&gt;
&lt;%# DataBinder.Eval(Container.DataItem, &quot;[/&quot;title_id/&quot;]&quot;)%&gt;
&lt;br&gt;
&lt;/itemtemplate&gt;
&lt;/asp:repeater&gt;
&lt;!-- 子Repeater结束 --&gt;
&lt;/itemtemplate&gt;
&lt;/asp:repeater&gt;
&lt;!-- 父Repeater结束 --&gt;
&lt;/form&gt;
&lt;/body&gt;
&lt;/HTML&gt;

NestedRepeater.aspx.cs

using System;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace eMeng
{
/// &lt;summary&gt;
/// NestedRepeater 的摘要说明。
/// 本文介绍如何利用Repeater控件显示主－从关系的表格
/// &lt;/summary&gt;
public class NestedRepeater : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Repeater parentRepeater;
public void Page_Load(object sender, EventArgs e)
{
// 为Authors表创建 Connection 和 DataAdapter
string cnnString = @&quot;server=(local);database=pubs; Integrated Security=SSPI;&quot;;
SqlConnection cnn = new SqlConnection(cnnString);
SqlDataAdapter cmd1 = new SqlDataAdapter(&quot;select * from authors&quot;,cnn);
//创建填充 DataSet.
DataSet ds = new DataSet();
cmd1.Fill(ds,&quot;authors&quot;);
// 为Titles表创建 DataAdapter
SqlDataAdapter cmd2 = new SqlDataAdapter(&quot;select * from titleauthor&quot;,cnn);
cmd2.Fill(ds,&quot;titles&quot;);
// 创建 Authors 表和 Titles 表之间的关系.
ds.Relations.Add(&quot;myrelation&quot;,
ds.Tables[&quot;authors&quot;].Columns[&quot;au_id&quot;],
ds.Tables[&quot;titles&quot;].Columns[&quot;au_id&quot;]);
// 绑定Authors到父Repeater
parentRepeater.DataSource = ds.Tables[&quot;authors&quot;];
Page.DataBind();
cnn.Close();
cnn.Dispose();
}
private void Page_Init(object sender, EventArgs e)
{
InitializeComponent();
}
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
public NestedRepeater()
{
Page.Init += new System.EventHandler(Page_Init);
}
}
}