用C# + SqlServer2005 实现的treeview动态树形菜单

using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using Syste

using system;
using system.data;
using system.configuration;
using system.collections;
using system.web;
using system.web.security;
using system.web.ui;
using system.web.ui.webcontrols;
using system.web.ui.webcontrols.webparts;
using system.web.ui.htmlcontrols;
using system.data.sqlclient;

public partial class TreeView : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnTV_Click(object sender, EventArgs e)
    {
        CreateTreeView(TreeView1.Nodes, "0");
    }

    /**/
    ///

    /// 根据递归查询结果动态生成TreeView
    ///

    private DataSet CreateDataSet()
    {
        string connetion = "database=test;server=.;uid=sa;pwd=sa123456;";
        using (SqlConnection con = new SqlConnection(connetion))
        {
            SqlCommand com = new SqlCommand("select * from QuHua", con);
           
            SqlDataAdapter da = new SqlDataAdapter(com);
            DataSet ds = new  DataSet();
            da.Fill(ds,"tree");
           

            return ds;
        }

    }

    ///

    /// 递归查询
    ///

    /// TreeView的节点集合
    /// 所属父级的ID
    private void CreateTreeView(TreeNodeCollection nodes, string parentid)
    {
        DataView TempDV = new DataView();
        TreeNode TempNode;
        //string intId;
        TempDV.Table = CreateDataSet().Tables["tree"];
        TempDV.RowFilter = "ParentID=" + parentid + "";
        foreach (DataRowView drv in TempDV)
        {
            TempNode = new TreeNode();
            TempNode.Value = drv["TreeID"].ToString();
            TempNode.Text = drv["TreeName"].ToString();
            TempNode.NavigateUrl = drv["NodeUrl"].ToString();
            nodes.Add(TempNode);

            //intId = drv["ParentID"].ToString();

            CreateTreeView(TempNode.ChildNodes, TempNode.Value);

        }

    }

}