<asp:DataList ID="dlProBigType" runat="server" Width="50%"> <ItemTemplate> <table cellpadding="3" cellspacing="1" width="100%" border="1" bordercolor="#CCCCCC" style="border-collapse: collapse;" mce_style="border-collapse: collapse;"> <tr> <td align="left" style="width: 50%"> <img src="Images/add.gif" mce_src="Images/add.gif" width="15" height="15"><%#Eval("BigTypeName") %></td> <td align="left" style="width: 10%"> <%#Eval("BigTypeSort") %> </td> <td align="right" style="width: 40%"> <a href="ProSmallType_Add.aspx?id=<%#Eval(" mce_href="ProSmallType_Add.aspx?id=<%#Eval("ID") %>">添加小类</a> - <a href="ProType_Edit.aspx?id=<%#Eval(" mce_href="ProType_Edit.aspx?id=<%#Eval("ID") %>"> 修改</a> - <a href="#" mce_href="#" οnclick="javascript:if (confirm('确定删除此类别吗?')) window.location.href='ProType_Del.aspx?id=<%#Eval("ID") %>';"> 删除</a> </td> </tr> <asp:Repeater ID="rpProSmallType" runat="server" DataSource='<%#((DataRowView)Container.DataItem).Row.GetChildRows("myrelation") %>'> <ItemTemplate> <tr> <td align="left"> <img src="images/sub.gif" mce_src="images/sub.gif" width="15" height="15"><%#Eval("[/"SmallTypeName/"]")%></td> <td align="center"> <%#Eval("[/"SmallTypeSort/"]")%> </td> <td align="right"> <a href="ProSmallType_Edit.aspx?id=<%#Eval(" mce_href="ProSmallType_Edit.aspx?id=<%#Eval("[/"ID/"]")%>">修改</a> - <a href="#" mce_href="#" οnclick="javascript:if (confirm('确定删除此类别吗?')) window.location.href='ProSmallType_Del.aspx?id=<%#Eval("[/"ID/"]")%>';"> 删除</a> </td> </tr> </ItemTemplate> </asp:Repeater> </table> </ItemTemplate> </asp:DataList> private void BindData() { DataSet dset = new DataSet(); this.ConnectDatabase(); SqlDataAdapter da = new SqlDataAdapter("select * from Web_ProBigType order by BigTypeSort, ID", conn); da.Fill(dset, "Web_ProBigType"); SqlDataAdapter da1 = new SqlDataAdapter("select * from Web_ProSmallType order by SmallTypeSort, ID", conn); da1.Fill(dset, "Web_ProSmallType"); this.DisConnectDatabase(); dset.Relations.Add("myrelation", dset.Tables["Web_ProBigType"].Columns["ID"], dset.Tables["Web_ProSmallType"].Columns["BigTypeID"]); this.dlProBigType.DataSource = dset.Tables["Web_ProBigType"]; this.dlProBigType.DataBind(); }