asp.net repeat嵌套(3)
<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>
<%# DataBinder.Eval(Container.DataItem, "[\"title_id\"]")%><br>
</itemtemplate>
</asp:Repeater>
</itemtemplate>
</asp:Repeater>
6. Add the following page directive to the top of the page:
7. <%@ Import Namespace="System.Data" %>
8. In the code-behind page, replace the following line in the Page_Load event
9. //Insert code in step 4 of the next section here.
with the following code:
//Create a second DataAdapter for the Titles table.
SqlDataAdapter cmd2 = new SqlDataAdapter("select * from titleauthor",cnn);
cmd2.Fill(ds,"titles");
//Create the relation between the Authors and Titles tables.
ds.Relations.Add("myrelation",
ds.Tables["authors"].Columns["au_id"],
ds.Tables["titles"].Columns["au_id"]);
This adds the Titles table to the DataSet, and then adds the relationships between the Authors and Titles tables.
10. Save and compile the application.
11. View the page in the browser, and then verify that the page works so far. The output should appear as follows:
172-32-1176
PS3333
213-46-8915
BU1032
BU2075
238-95-7766
PC1035
267-41-2394
BU1111
TC7777
...
Complete Code List
Nestedrepeater.aspx
<%@ Page language="c#" Codebehind="NestedRepeater.aspx.cs" AutoEventWireup="false" Inherits="NestedRepeater.NestedRepeater" %>
<%@ Import Namespace="System.Data" %>
<html>
<body>
<form runat=server>
<!-- start parent repeater -->
相关新闻>>
- 发表评论
-
- 最新评论 更多>>
