<asp:Repeater id="Repeater1" runat="server" OnItemDataBound="Repeater1_ItemDataBound1">
<ItemTemplate>
<font color=blue><%#DataBinder.Eval(Container.DataItem, "username")%></font> <br />
<asp:Repeater ID="Repeater2" runat="server" OnItemDataBound="Repeater2_ItemDataBound1">
<ItemTemplate>
<font color=red><%#DataBinder.Eval(Container.DataItem, "username")%></font><br />
<asp:Repeater ID="Repeater3" runat="server">
<ItemTemplate>
<%#DataBinder.Eval(Container.DataItem, "username")%>
</ItemTemplate>
</asp:Repeater>
<br />
</ItemTemplate>
</asp:Repeater>
<hr />
</ItemTemplate>
</asp:Repeater>
private void BindGrid()
{
string sql = "select top 5 username from [user] order by userid desc";
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("test.mdb"));
OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds, "temp");
Repeater1.DataSource = ds.Tables["temp"];
Repeater1.DataBind();
}
protected void Repeater1_ItemDataBound1(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Repeater Repeater2 = (Repeater)e.Item.FindControl("Repeater2");
DataRowView rowv = (DataRowView)e.Item.DataItem;
string username = rowv["username"].ToString();
string sql2 = "select top 5 username from [user] where username='" + username + "'";
DataSet ds2 = GetDs(sql2, "temp");
Repeater2.DataSource = ds2.Tables[0];
Repeater2.DataBind();
}
}
protected void Repeater2_ItemDataBound1(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Repeater Repeater3 = (Repeater)e.Item.FindControl("Repeater3");
DataRowView rowv = (DataRowView)e.Item.DataItem;
string username = rowv["username"].ToString();
string sql3 = "select top 5 username from [user] where username='" + username + "'";
DataSet ds3 = GetDs(sql3, "temp");
Repeater3.DataSource = ds3.Tables[0];
Repeater3.DataBind();
}
}
public DataSet GetDs(string sql, string table)
{
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("test.mdb"));
OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);
DataSet ds = new DataSet();
ds.Clear();
da.Fill(ds, table);
return ds;
}
演示 下载