<asp:Repeater ID="Repeater1" runat="server">
<itemtemplate>
<table>
<tr>
<%# DataBinder.Eval(Container.DataItem, "c_name") %><br>
<asp:Repeater ID="Repeater2" runat="server">
<itemtemplate>
<a href='Article_Detile.aspx?Id=<%# DataBinder.Eval(Container.DataItem, "a_id") %>'>
<%# DataBinder.Eval(Container.DataItem, "a_title") %><br>
</a>
</itemtemplate>
</asp:Repeater>
</tr>
</table>
</itemtemplate>
</asp:Repeater>
后台程序:
1
public
void
loadclassdata()
2 {
3 string connstr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = '"+Server.MapPath("../DataBase/DB.mdb")+"'";
4 string commstr = "select * from tb_class";
5
6 OleDbConnection conn = new OleDbConnection(connstr);
7 OleDbCommand comm = new OleDbCommand(commstr,conn);
8
9 DataSet myds = new DataSet();
10
11 OleDbDataAdapter myadapter = new OleDbDataAdapter(comm);
12
13 try
14 {
15 myadapter.Fill(myds,"tb_class");
16 this.Repeater1.DataSource=myds.Tables["tb_class"].DefaultView;
17 this.Repeater1.DataBind();
18 }
19 catch(Exception ex)
20 {
21 Response.Write(ex.Message);
22 }
23 finally
24 {
25
26 }
27 }
28
29 private void Repeater1_ItemCreated( object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e)
30 {
31 object cid;
32 cid = DataBinder.Eval(e.Item.DataItem,"c_id");
33 Repeater Repeater2;
34 Repeater2=(Repeater)e.Item.FindControl("Repeater2");
35 string connstr="Provider = Microsoft.Jet.OLEDB.4.0;Data Source = '"+Server.MapPath("../DataBase/DB.mdb")+"'";
36 string commstr = "select * from tb_article";
37 OleDbConnection conn=new OleDbConnection(connstr);
38 OleDbCommand cmd=new OleDbCommand(commstr,conn);
39 OleDbDataAdapter da=new OleDbDataAdapter(cmd);
40 DataSet ds=new DataSet();
41 da.Fill(ds,"tb_article");
42 Repeater2.DataSource=ds.Tables["tb_article"].DefaultView;
43 Repeater2.DataBind();
44 }
2 {
3 string connstr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = '"+Server.MapPath("../DataBase/DB.mdb")+"'";
4 string commstr = "select * from tb_class";
5
6 OleDbConnection conn = new OleDbConnection(connstr);
7 OleDbCommand comm = new OleDbCommand(commstr,conn);
8
9 DataSet myds = new DataSet();
10
11 OleDbDataAdapter myadapter = new OleDbDataAdapter(comm);
12
13 try
14 {
15 myadapter.Fill(myds,"tb_class");
16 this.Repeater1.DataSource=myds.Tables["tb_class"].DefaultView;
17 this.Repeater1.DataBind();
18 }
19 catch(Exception ex)
20 {
21 Response.Write(ex.Message);
22 }
23 finally
24 {
25
26 }
27 }
28
29 private void Repeater1_ItemCreated( object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e)
30 {
31 object cid;
32 cid = DataBinder.Eval(e.Item.DataItem,"c_id");
33 Repeater Repeater2;
34 Repeater2=(Repeater)e.Item.FindControl("Repeater2");
35 string connstr="Provider = Microsoft.Jet.OLEDB.4.0;Data Source = '"+Server.MapPath("../DataBase/DB.mdb")+"'";
36 string commstr = "select * from tb_article";
37 OleDbConnection conn=new OleDbConnection(connstr);
38 OleDbCommand cmd=new OleDbCommand(commstr,conn);
39 OleDbDataAdapter da=new OleDbDataAdapter(cmd);
40 DataSet ds=new DataSet();
41 da.Fill(ds,"tb_article");
42 Repeater2.DataSource=ds.Tables["tb_article"].DefaultView;
43 Repeater2.DataBind();
44 }