asp.net repeat嵌套(2)
24. SqlDataAdapter cmd1 = new SqlDataAdapter("select * from authors",cnn);
25.
26. //Create and fill the DataSet.
27. DataSet ds = new DataSet();
28. cmd1.Fill(ds,"authors");
29. //Insert code in step 4 of the next section here.
30. //Bind the Authors table to the parent Repeater control, and call DataBind.
31. parentRepeater.DataSource = ds.Tables["authors"];
32. Page.DataBind();
33.
34. //Close the connection.
35. cnn.Close();
36. }
NOTE: You may have to modify the database connection string as appropriate for your environment.
37. Save all of the files.
38. In Solution Explorer, right-click the NestedRepeater.aspx, and then click Set As Start Page.
39. On the Build menu click Build Solution to compile the project.
40. View the .aspx page in the browser, and then verify that the page works thus far.
The output should appear as follows:
• 172-32-1176
• 213-46-8915
• 238-95-7766
• 267-41-2394
• ...
Bind to the Child Table
1. In the HTML view of the NestedRepeater.aspx page, locate the following line of code:
2. <b><%# DataBinder.Eval(Container.DataItem, "au_id") %></b><br>
Add the following code after this code:
<asp:repeater id="childRepeater" runat="server">
<itemtemplate>
<%# DataBinder.Eval(Container.DataItem, "[\"title_id\"]")%><br>
</itemtemplate>
</asp:repeater>
This new code adds a second Repeater control to the ItemTemplate property of the parent Repeatercontrol.
3. Set the DataSource property for the child Repeater control as follows:
4. <asp:repeater ... datasource='<%# ((DataRowView)Container.DataItem)
5. .Row.GetChildRows("myrelation") %>' >
After you set the DataSource property for the child Repeater control, the HTML code for the twoRepeater controls (parent and child) appears as follows:
相关新闻>>
- 发表评论
-
- 最新评论 更多>>