ASP.net主从表显示

来源：互联网发布：u盘格式化的数据恢复编辑：程序博客网时间：2024/05/16 18:25

ASPX:
<%@ Page language= "c# " Codebehind= "NestedRepeater.aspx.cs "
AutoEventWireup= "false " Inherits= "eMeng.NestedRepeater " %>
<%@ Import Namespace= "System.Data " %>

<HTML>
<body>
<form runat= "server ">

<asp:repeater id= "parentRepeater " runat= "server ">
<itemtemplate>
<b>
<%# DataBinder.Eval(Container.DataItem, "au_id ") %>
</b>
<br>

<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>

</itemtemplate>
</asp: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();