DataRelation 实现父子表 父子级 Repeater的嵌套使用

    if (!IsPostBack)
        {
            using (OleDbConnection con = new OleDbConnection(cn))
            {
                DataSet ds = new DataSet();

                OleDbDataAdapter dr1 = new OleDbDataAdapter("select * from km", con);
                OleDbDataAdapter dr2 = new OleDbDataAdapter("select * from km1", con);
                dr1.Fill(ds, "tb1");
                dr2.Fill(ds, "tb2");
                ds.Relations.Add("newtb", ds.Tables[0].Columns["id"], ds.Tables[1].Columns["flag"]);
                Repeater1.DataSource = ds;
                Repeater1.DataBind();

            }
        }

<asp:Repeater ID="Repeater1" runat="server">
    <ItemTemplate>
      <div class="adminleft" id='admin<%# Eval("id") %>'>
   <h2 id='h<%# Eval("id") %>' οnmοuseοut="fff('h<%# Eval("id") %>')" οnmοuseοver="f('h<%# Eval("id") %>')" οnclick="javascript:location.href='showbj.aspx?flag=<%# Eval("id") %>&na=<%# Eval("subject") %>'"><%#Eval("subject") %></h2>
      <ul>
        <asp:Repeater ID="Repeater2" runat="server" DataSource='<%# ((DataRowView)Container.DataItem).Row.GetChildRows("newtb") %>' OnItemCommand="Repeater1_ItemCommand">
        <ItemTemplate>
        <li><asp:LinkButton ID="LinkButton1" runat="server" CommandArgument='<%#Eval("[/"flag/"]") %>' CommandName="re"><%#Eval("[/"subject/"]") %></asp:LinkButton></li>
        </ItemTemplate>
        </asp:Repeater>
      </ul>
      </div>
    </ItemTemplate>
    </asp:Repeater>

 

 

转自http://hi.baidu.com/handboy/blog/item/73a8b33bfe630de214cecb77.html