前台代码
- <body>
- <form id="form1" runat="server">
- <!-- start parent repeater -->
- 例子一:
- <%--
- <asp:repeater id="parentRepeater" runat="server">
- <itemtemplate>
- <b><%# DataBinder.Eval(Container.DataItem, "TerritoryID")%></b><br>
- <!-- start child repeater -->
- <asp:repeater id="childRepeater" datasource='<%# ((System.Data.DataRowView)Container.DataItem).Row.GetChildRows("CustomerName") %>' runat="server">
- <itemtemplate>
- <%# DataBinder.Eval(Container.DataItem, "[/"CustomerName/"]")%><br>
- </itemtemplate>
- </asp:repeater>
- <!-- end child repeater -->
- </itemtemplate>
- </asp:repeater>--%>
- 例子二:
- <asp:repeater id="parentRepeater" runat="server">
- <itemtemplate>
- <b><%# DataBinder.Eval(Container.DataItem, "TerritoryID")%></b><br>
- <!-- start child repeater -->
- <!-- end child repeater -->
- </itemtemplate>
- <ItemTemplate>
- <table><tr><td> <img src="" /></td>
- <td><%# DataBinder.Eval(Container.DataItem, "Name")%></td>
- <td><%# DataBinder.Eval(Container.DataItem, "CountryRegionCode")%></td>
- </tr>
- </table>
- </ItemTemplate>
- </asp:repeater>
- <!-- end parent repeater -->
- </form>
- </body>
后台代码
- using System;
- using System.Data;
- using System.Data.SqlClient;
- using System.Web;
- using System.Web.SessionState;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- public partial class WebForm1 : System.Web.UI.Page
- {
- protected System.Web.UI.WebControls.Repeater parentRepeater;
- public void Page_Load(object sender, EventArgs e)
- {
- //Create the connection and DataAdapter for the Authors table.
- SqlConnection cnn = new SqlConnection("server=(local);database=sampledatabase; Integrated Security=SSPI ;");
- SqlDataAdapter cmd1 = new SqlDataAdapter("select * from TDemo_SalesTerritory",cnn);
- //Create and fill the DataSet.
- DataSet ds = new DataSet();
- cmd1.Fill(ds, "SalesTerritory");
- //Create a second DataAdapter for the Titles table.
- SqlDataAdapter cmd2 = new SqlDataAdapter("select * from TDemo_CustomerInfo",cnn);
- cmd2.Fill(ds, "CustomerInfo");
- //Create the relation bewtween the Authors and Titles tables.
- ds.Relations.Add("CustomerName", ds.Tables["SalesTerritory"].Columns["TerritoryID"], ds.Tables["CustomerInfo"].Columns["TerritoryID"]);
- //Bind the Authors table to the parent Repeater control, and call DataBind.
- parentRepeater.DataSource = ds.Tables["SalesTerritory"];
- Page.DataBind();
- //Close the connection.
- cnn.Close();
- }
- }