treeview.aspx.cs

关于ASP.NET制作程序模块

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)
    {
        if (!Page.IsPostBack)
        {   ///显示数据
            bandtree("0");
        }
    }

    public void bandtree(string seldate)
    {
        DataTable dataTable = bind().Tables[0];
        this.TreeView1.Nodes.Clear();     ///清空树的所有节点
        DataRow[] rowList = dataTable.Select("parentid='0'");
        if (rowList.Length <= 0)
        return;
        ///创建根节点
        TreeNode rootNode = new TreeNode();
        ///设置根节点属性
        rootNode.Text = rowList[0]["nodename"].ToString();
        rootNode.Value = rowList[0]["nodeid"].ToString(); ///设置根节点的Key值    
        rootNode.Expanded = true;  //树的节点展开
        ///添加根节点
        TreeView1.Nodes.Add(rootNode);
        ///创建其他节点
        childnode(rootNode, seldate);
    }

    private void childnode(TreeNode parentNode, string seldate)
    {
        DataTable datatable1 = bind().Tables[0];
        ///选择数据时，添加了排序表达式OrderBy
        DataRow[] rowList = datatable1.Select("parentid='" + parentNode.Value + "'");
        foreach (DataRow row in rowList)
        {   ///创建新节点
            TreeNode node = new TreeNode();
            ///设置节点的属性
            node.Text = row["nodename"].ToString();
            node.Value = row["nodeid"].ToString();
            node.NavigateUrl = row["url"].ToString();
            node.Expanded = true;
            parentNode.ChildNodes.Add(node);
            ///递归调用，创建其他节点
            childnode(node, seldate);
        }
    }
    private DataSet bind()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
        con.Open();
        string cmdtext = "select * from Treeviewtable";
        SqlDataAdapter sda = new SqlDataAdapter(cmdtext, con);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        return ds;
    }

   
}