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();
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
