asp.net 控制項的嵌套

/* 增加關係 */
//後台代碼
SqlConnection cnn = new SqlConnection("server=(local);database=pubs;uid=sa;pwd=qinfei;");
SqlDataAdapter cmd1 = new SqlDataAdapter("select * from authors",cnn);
DataSet ds = new DataSet();
cmd1.Fill(ds,"authors");
SqlDataAdapter cmd2 = new SqlDataAdapter("select * from titleauthor",cnn);
cmd2.Fill(ds,"titles");
ds.Relations.Add("myrelation", ds.Tables["authors"].Columns["au_id"], ds.Tables["titles"].Columns["au_id"]);
parent.DataSource = ds.Tables["authors"];
Page.DataBind();
cnn.Close();

//頁面代碼
<!-- 父控制項 -->
<asp:Repeater id="parent" runat="server">
   <ItemTemplate>
      <b> <%# DataBinder.Eval(Container.DataItem,"au_id") %></b> <br>
      <!-- 子控制項 -->                           <!-- 捆綁資料來源,在後台已建立了myrelation 的關係  -->
      <asp:Repeater id="child" datasource='<%# ((DataRowView)Container.DataItem).Row.GetChildRows("myrelation") %>' runat="server"> 
         <ItemTemplate>
            <%# DataBinder.Eval(Container.DataItem, "[\"title_id\"]")%> <br>  <!-- 子控制項捆綁資料後調用資料時,方法內的Row參數需加 [""] -->
         </ItemTemplate>
      </asp:Repeater>
      <!-- 子控制項 -->
   </ItemTemplate>
</asp:Repeater>
<!-- 父控制項 -->

/* 給子控制項捆綁資料來源 */
//後台代碼
private void Page_Load(object sender, System.EventArgs e)
{
   if(!IsPostBack)
      BindData();
}
//取得資料
private void BindData()
{
   string sqlStmt = "SELECT * FROM Customers; SELECT * FROM Orders";
   string conString = "server=localhost;database=Northwind;uid=sa;pwd=;";

   SqlDataAdapter sda = new SqlDataAdapter(sqlStmt, conString);

   sda.Fill(ds);
   ds.Tables[0].TableName = "Customers";
   ds.Tables[1].TableName = "Orders";

   DataGrid1.DataSource = ds.Tables["Customers"];
   DataGrid1.DataBind();
}
//取返回數的方法,前台頁面子控制項中可直接調用
protected DataView getOrdersDataSource(string _customerID)
{
   DataView _orders = ds.Tables["Orders"].DefaultView;
   _orders.RowFilter = "CustomerID='" + _customerID + "'";
   return _orders;
}
//同上,不帶參數
protected DataView getOrdersDataSource1()
{
   DataView _orders = ds.Tables["Orders"].DefaultView;
   _orders.RowFilter = "CustomerID='BSBEV'";
   return _orders;
}

//頁面代碼
<!-- 父控制項 -->
<asp:DataGrid id="DataGrid1" runat="server">
   <Columns>
      <asp:TemplateColumn ItemStyle-VerticalAlign="Top" HeaderText="Orders" ItemStyle-Width="100%">
      <ItemTemplate>
         父控制項 <%# DataBinder.Eval(Container.DataItem, "CustomerID") %>
         <!-- 子控制項 -->          
         <asp:DataGrid runat="server" AutogenerateColumns="False" Width="100%" DataSource='<%# getOrdersDataSource1() %>' ID="Datagrid2" NAME="Datagrid2">
            <Columns>
               <asp:BoundColumn DataField="OrderID" HeaderText="Order ID" /><asp:TemplateColumn>
               <ItemTemplate><%# DataBinder.Eval(Container.DataItem, "OrderDate", "子控制項={0}" ) %></ItemTemplate>
               </asp:TemplateColumn>
            </Columns>
         </asp:DataGrid>
         <!-- 子控制項 -->
     </ItemTemplate>
     </asp:TemplateColumn>
   </Columns>
</asp:DataGrid>
<!-- 父控制項 -->