利用TreeView控件动态生成无限级树

 

1. public partial class _Default : System.Web.UI.Page 
2. {
3.     protected void Page_Load(object sender, EventArgs e)
4.     {
5.         if (!IsPostBack)
6.         {
7.             TreeNode rootnode = new TreeNode();
8.             rootnode.Text = "无限级菜单";
9.             rootnode.Expanded = true;
10.             TreeView1.Nodes.Add(rootnode);
11.             CreateNode(0, rootnode);
12.         }
13.        
14.     }
15.     void CreateNode(int id,TreeNode rootnode)
16.     {
17.         SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=MyOA;Integrated Security=True");
18.         SqlCommand cmd = new SqlCommand();
19.         cmd.Connection = conn;
20.         cmd.CommandType = CommandType.Text;
21.         cmd.CommandText = "select * from tree where belong="+id;
22.         DataSet ds = new DataSet();
23.         SqlDataAdapter sa = new SqlDataAdapter();
24.         sa.SelectCommand = cmd;
25.         sa.Fill(ds);
26.         foreach (DataRow dr in ds.Tables[0].Rows)
27.         {
28.             TreeNode node = new TreeNode();
29.             node.Expanded = true;
30.             node.Text = dr["text"].ToString();
31.             node.ShowCheckBox = true;
32.             int treeid= int.Parse(dr["id"].ToString().Trim());
33.             rootnode.ChildNodes.Add(node);
34.             CreateNode(treeid, node);
35.         }
36.     }
37. }

数据库里的数据格式是这样的
--------------------------------------------------------
id                    text                     belong
1                     aaaa                         0
2                     bbbb                        0
3                     cccc                         0
4                     dddd                        1
5                     eeee                         2
6                     ffff                          4

--------------------------------------------------------