父子Repeater

来源:互联网 发布:js实现轮播思路 编辑:程序博客网 时间:2024/05/01 09:20

      <!-- 父Repeater开始 -->
   <asp:repeater id="parentRepeater" runat="server">
   <itemtemplate>
    <b>
    <%# DataBinder.Eval(Container.DataItem, "title")%>
    </b>
    <br>
    <!-- 子Repeater开始 -->
    <asp:repeater id="childRepeater" runat="server"
        datasource='<%# ((DataRowView)Container.DataItem).Row.GetChildRows("myrelation") %>'>
    <itemtemplate>
     <%# DataBinder.Eval(Container.DataItem, "[/"title/"]")%>
     <br>
    </itemtemplate>
    </asp:repeater>
    <!-- 子Repeater结束 -->
   </itemtemplate>
   </asp:repeater>
   <!-- 父Repeater结束 -->

//查询出所有新闻和已回复日志新闻
  private void List()
  {
   string strconn = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
   SqlConnection conn= new SqlConnection(strconn);
   conn.Open();
   string strSql1 =  " select * from guestbookArticle where is_del=0 and parentId=0 order by id desc";
   SqlDataAdapter da1 = new SqlDataAdapter(strSql1,conn);
   DataSet ds = new DataSet();
   da1.Fill(ds,"parent");

   string strSql2 = " select * from guestbookArticle where is_del=0 and parentId<>0 order by id desc";
   SqlDataAdapter da2 = new SqlDataAdapter(strSql2,conn);
   da2.Fill(ds,"child");

   ds.Relations.Add("myrelation",
    ds.Tables["parent"].Columns["id"],
    ds.Tables["child"].Columns["parentId"]);

   parentRepeater.DataSource = ds.Tables["parent"];
   Page.DataBind();

  } 

原创粉丝点击