vs2005中treeview实现树形菜单

 

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
//using Microsoft.Web.UI.WebControls;
using System.Data.SqlClient;

public partial class treeview树形菜单_Default : System.Web.UI.Page
...{
    protected void Page_Load(object sender, EventArgs e)
    ...{
        //value="server=60.191.135.155;database=sowdotest;uid=sa;pwd=sowdosql2008"/>
        // 定义数据库连接
        SqlConnection CN = new SqlConnection();
        try
        ...{
           // 初始化连接字符串
            CN.ConnectionString = "server=60.12.125.155;database=ceshi;uid=21;pwd=s1w12008";
            CN.Open();

            SqlDataAdapter adp = new SqlDataAdapter("select * from tbTree", CN);
            DataSet ds = new DataSet();
            adp.Fill(ds);
            this.ViewState["ds"] = ds;
        }
        catch (Exception ex)
        ...{
            Session["Error"] = ex.ToString();
            Response.Redirect("error.aspx");       //̀跳转程序的公共错误处理页面
        }
        finally
        ...{
            CN.Close();
        }
        //调用递归函数，完成树形结构的生成
        AddTree(0, (TreeNode)null);


    }
    //递归添加树的节点
    public void AddTree(int ParentID, TreeNode pNode)
    ...{
        DataSet ds = (DataSet)this.ViewState["ds"];
        DataView dvTree = new DataView(ds.Tables[0]);
        //过滤ParentID,得到当前的所有子节点
        dvTree.RowFilter = "[PARENTID] = " + ParentID;

        foreach (DataRowView Row in dvTree)
        ...{
            TreeNode Node1 = new TreeNode();
            if (pNode == null)
            ...{    //添加根节点
                Node1.Text = Row["ConText"].ToString();
                TreeView1.Nodes.Add(Node1);
                Node1.Expanded = true;
                Node1.NavigateUrl = "#";
                AddTree(Int32.Parse(Row["ID"].ToString()), Node1);    //再次递归
            }
            else
            ...{   //̀添加当前节点的子节点
                Node1.Text = Row["ConText"].ToString();
                pNode.ChildNodes.Add(Node1);
                Node1.Expanded = true;
                Node1.NavigateUrl = "#";
                AddTree(Int32.Parse(Row["ID"].ToString()), Node1);     //再次递归
            }
        }
    }            

}