ASPX:
<%@ Page language= "c# " Codebehind= "NestedRepeater.aspx.cs "
AutoEventWireup= "false " Inherits= "eMeng.NestedRepeater " %>
<%@ Import Namespace= "System.Data " %>
<HTML>
<body>
<form runat= "server ">
<!-- 父Repeater开始 -->
<asp:repeater id= "parentRepeater " runat= "server ">
<itemtemplate>
<b>
<%# DataBinder.Eval(Container.DataItem, "au_id ") %>
</b>
<br>
<!-- 子Repeater开始 -->
<asp:repeater id= "childRepeater " runat= "server " datasource= ' <%# ((DataRowView)Container.DataItem).Row.GetChildRows( "myrelation ") %> '>
<itemtemplate>
<font color=red> <%# DataBinder.Eval(Container.DataItem, "[/ "title_id/ "] ")%>
___
<%# DataBinder.Eval(Container.DataItem, "[/ "au_ord/ "] ")%>
</font>
<br>
</itemtemplate>
</asp:repeater>
<!-- 子Repeater结束 -->
</itemtemplate>
</asp:repeater>
<!-- 父Repeater结束 -->
</form>
</body>
</HTML>
CS:
// 为Authors表创建 Connection 和 DataAdapter
string cnnString = @ "server=(local);password=password;database=pubs; Integrated Security=SSPI; ";
SqlConnection cnn = new SqlConnection(cnnString);
SqlDataAdapter cmd1 = new SqlDataAdapter( "select * from authors ",cnn);
//创建填充 DataSet.
DataSet ds = new DataSet();
cmd1.Fill(ds, "authors ");
// 为Titles表创建 DataAdapter
SqlDataAdapter cmd2 = new SqlDataAdapter( "select * from titleauthor ",cnn);
cmd2.Fill(ds, "titles ");
// 创建 Authors 表和 Titles 表之间的关系.
ds.Relations.Add( "myrelation ",
ds.Tables[ "authors "].Columns[ "au_id "],
ds.Tables[ "titles "].Columns[ "au_id "]);
// 绑定Authors到父Repeater
parentRepeater.DataSource = ds.Tables[ "authors "];
Page.DataBind();
cnn.Close();
cnn.Dispose();
ASP.net主从表显示
最新推荐文章于 2024-07-24 22:04:52 发布