公告

用Repeater控件显示主从关系数据表

TOP.ASPX

<%@ Page Debug="true" language="c#" Codebehind="Top.aspx.cs" Inherits="QA.Top" %>

<%@ Page Debug="true" language="c#" Codebehind="Top.aspx.cs" Inherits="QA.Top" %>
2

<HTML>
4

<HEAD>
5

<title>Top</title>
6

</HEAD>
8

<body>
9

<form id="Form1" method="post" runat="server">
10

<asp:repeater ID="Class" runat="server" OnItemCreated="Class_ItemCreated">
11

<itemtemplate> <br><b><%# DataBinder.Eval(Container.DataItem, "ClassName") %>:</b>
12

<asp:repeater ID="Forum" runat="server">
13

<itemtemplate><%# DataBinder.Eval(Container.DataItem, "ClassName") %>
14

</itemtemplate>
15

</asp:repeater>
16

</itemtemplate>
17

</asp:repeater>
18

</form>
19

</body>
20

</HTML>
21

Top.aspx.cs

using System;
2

using System.Configuration;
3

using System.Data;
4

using System.Data.OleDb;
5

using System.Text;
6

using System.Web;
7

using System.Web.UI;
8

using System.Web.UI.WebControls;
9

using System.Web.UI.HtmlControls;
10

namespace QA
12

{
13

/// <summary>
14

/// Top 的摘要说明。
15

/// </summary>
16

public class Top : System.Web.UI.Page
17

{
18

/// <summary>
19

/// 数据库连接
20

/// </summary>
21

public static string strConn
23

{
24

get
25

{
26

StringBuilder strResult = new StringBuilder(ConfigurationSettings.AppSettings["Provider"]);
27

strResult.Append("; ");
28

strResult.Append("Data Source = ");
29

strResult.Append(HttpContext.Current.Server.MapPath("."));
30

strResult.Append("\\");
31

strResult.Append(ConfigurationSettings.AppSettings["DataSource"]);
32

return strResult.ToString();
33

}
34

}
35

protected string strSQL;
36

protected OleDbDataAdapter Adpt = new OleDbDataAdapter();
37

protected DataSet Ds = new DataSet();
38

protected OleDbConnection Conn = new OleDbConnection(strConn);
39

protected Repeater Class = new Repeater();
40

protected OleDbCommand Cmd = new OleDbCommand();
41

private void Page_Load(object sender, System.EventArgs e)
43

{
44

if(!Page.IsPostBack)
45

{
46

strSQL = "SELECT * FROM Qclass WHERE Dclass = 0";
47

Adpt = new OleDbDataAdapter(strSQL, Conn);
48

Adpt.Fill(Ds, "Class");
49

Class.DataSource = Ds.Tables["Class"].DefaultView;
50

Class.DataBind();
51

}
52

}
54

protected DataTable Forum_Source(int id)
55

{
56

if (Ds.Tables.Contains("Forum") && Ds.Tables.CanRemove(Ds.Tables["Forum"]))
57

Ds.Tables.Remove("Forum");
58

strSQL = "SELECT * FROM Qclass WHERE Dclass = @id";
59

Cmd = new OleDbCommand(strSQL, Conn);
60

Cmd.Parameters.Add(new OleDbParameter("@id", OleDbType.Integer)).Value = id;
61

Adpt = new OleDbDataAdapter(Cmd);
62

Adpt.Fill(Ds, "Forum");
63

return Ds.Tables["Forum"];
64

}
65

//控件调用的OnItemCreated类
66

protected void Class_ItemCreated(object sender, RepeaterItemEventArgs e)
67

{
68

((Repeater)e.Item.FindControl("Forum")).DataSource = Forum_Source(int.Parse(((System.Data.DataRowView)e.Item.DataItem)["id"].ToString())).DefaultView;
69

}
70

}
72

}
73

<%# DataBinder.Eval(Container.DataItem, "ClassName") %>

数据库表如下:

当Dclass为0时,此分类为主分类,当Dclass不为0时为小分类,并与主分类ID对应!

posted on 2007-08-05 09:59 江宇旋阅读(432) 评论(0) 收藏举报

刷新页面返回顶部

jiangyuxuan

公告

用Repeater控件显示主从关系数据表