<!-- 父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();
}