asp.net repeat嵌套

Bind to the Parent Table
1. Start Microsoft Visual Studio .NET.
2. On the File menu, point to New, and then click Project.
3. Click Visual C# Projects under Project Types, and then click ASP.NET Web Application underTemplates.
4. In the Location box, delete the WebApplication#, and then type NestedRepeater. If you use the local server, leave the server name as http://localhost. The following path appears in the Location box:
http://localhost/ NestedRepeater
Click OK.
5. In Solution Explorer, right-click the NestedRepeater project name node, point to Add, and then clickAdd Web Form.
6. To name the Web Form, type NestedRepeater, and click Open.
7. The new Web Form is created. It opens in Design View in the Integrated Development Environment (IDE) of Microsoft Visual Studio .NET. From the Toolbox, select the Repeater control, and then drag it to the Web Form page.
8. Change the ID property of this Repeater control to parentRepeater.
9. Switch to the HTML view for this Web Form. To do so, click the HTML tab in the lower-left corner of the Designer. The Repeater control generates the following HTML code:
10. <asp:Repeater id="parentRepeater" runat="server"></asp:Repeater>
     
11. Add the following code in the Repeater tags:
12. <itemtemplate>
13.      <b><%# DataBinder.Eval(Container.DataItem, "au_id") %></b><br>
14. </itemtemplate>
     
After you do that, the HTML code for the Repeater is as follows:
<asp:Repeater id="parentRepeater" runat="server">
 <itemtemplate>
      <b><%# DataBinder.Eval(Container.DataItem, "au_id") %></b><br> 
      </itemtemplate>
</asp:Repeater>
     
15. In Solution Explorer, right-click NestedRepeater.aspx, and then click View Code to switch to the NestedRepeater.aspx.cs code-behind file.
16. Add the following namespace declaration to the top of the file:
17. using System.Data;
18. using System.Data.SqlClient;
     
19. Add the following code to the Page_Load event to create a connection to the Pubs database, and then to bind the Authors table to the Repeater control:
20.       public void Page_Load(object sender, EventArgs e)
21.       {
22.          //Create the connection and DataAdapter for the Authors table.
23.          SqlConnection cnn = new SqlConnection("server=(local);database=pubs; Integrated Security=SSPI");