Heim > Datenbank > MySQL-Tutorial > 用C# + SqlServer2005 实现的treeview动态树形菜单

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Freigeben: 2016-06-07 15:08:43
Original
1103 Leute haben es durchsucht

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);

        }

    }

}

Verwandte Etiketten:
Erklärung dieser Website
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Beliebte Tutorials
Mehr>
Neueste Downloads
Mehr>
Web-Effekte
Quellcode der Website
Website-Materialien
Frontend-Vorlage