递归树

1. using System;
2. using System.Data;
3. using System.Configuration;
4. using System.Collections;
5. using System.Web;
6. using System.Web.Security;
7. using System.Web.UI;
8. using System.Web.UI.WebControls;
9. using System.Web.UI.WebControls.WebParts;
10. using System.Web.UI.HtmlControls;
11. using System.Collections.Generic;
12. using System.Data.SqlClient;
14. public partial class Default2 : System.Web.UI.Page
15. {
16.     IList<Category> list = new List<Category>();
18.     protected void Page_Load(object sender, EventArgs e)
19.     {
20.         if (!this.IsPostBack)
21.         {
22.             SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=;database=coll");
23.             SqlCommand cmd = new SqlCommand("select * from category", con);
24.             con.Open();
25.             SqlDataReader reader = cmd.ExecuteReader();
26.             while (reader.Read())
27.             {
28.                 Category c = new Category();
29.                 c.CategoryID = reader.GetInt32(0);
30.                 c.ParentID = reader.GetInt32(1);
31.                 c.Layer = reader.GetInt32(2);
32.                 c.Name = reader.GetString(3);
33.                 list.Add(c);
34.             }
35.             reader.Close();
36.             cmd.Dispose();
37.             con.Close();
39.             this.AddTreeNode(0, null);
40.         }
41.     }
43.     private void AddTreeNode(int parentId, TreeNode node)
44.     {
45.         List<Category> categorylist = new List<Category>();
46.         foreach (Category c in this.list)
47.         {
48.             if (c.ParentID == parentId)
49.                 categorylist.Add(c);
50.         }
52.         if (categorylist.Count > 0)
53.         {
54.             foreach (Category cate in categorylist)
55.             {
56.                 TreeNode tNode = new TreeNode();
57.                 tNode.Text = cate.Name;
58.                 if (node == null)
59.                 {
60.                     this.TreeView1.Nodes.Add(tNode);
61.                 }
62.                 else
63.                 {
64.                     node.ChildNodes.Add(tNode);
65.                 }
66.                 this.AddTreeNode(cate.CategoryID, tNode);
67.             }
68.         }
69.     }
70. }