【Vegas原创】更加快速的方法：HashTable遍历TreeView

最新推荐文章于 2025-08-16 22:13:48 发布

weixin_34400525

最新推荐文章于 2025-08-16 22:13:48 发布

阅读量67

点赞数

文章标签： ui 数据库

本文介绍如何使用 ASP.NET 和 C# 构建动态树视图，通过从数据库获取结构化数据并利用 Hashtable 实现父子节点关系，最终将数据展示为树形结构。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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;

public partial class treeview : System.Web.UI.Page
{
    DBAccess db = new DBAccess();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            hashTable();
        }
    }
    public DataTable GetTreeTable()
    {

        DataTable dt = db.GetDataTable("select * from trvAdmin order by id");
        return dt;
    }

    void hashTable()
    {
        DataTable dtregion = GetTreeTable();
        Hashtable httree = new Hashtable();
        foreach (DataRow myrow in dtregion.Rows)
        {
            TreeNode newnode = new TreeNode();
            newnode.Value = myrow["ID"].ToString();
            newnode.Text = myrow["TableName"].ToString();
            newnode.Target = myrow["Target"].ToString();
            newnode.NavigateUrl = myrow["url"].ToString();
            newnode.ImageToolTip = myrow["ParentID"].ToString();
            newnode.Expanded = bool.Parse(myrow["expanded"].ToString());
            httree.Add(newnode.Value, newnode);
        }
        foreach (DataRow treerow in dtregion.Rows)
        {
            TreeNode newnode = (TreeNode)httree[treerow["ID"].ToString()];
            TreeNode parentnode = (TreeNode)httree[newnode.ImageToolTip];

            if (parentnode != null)
            {
                parentnode.ChildNodes.Add(newnode);

            }
            else
            {
                this.TreeView1.Nodes.Add(newnode);
            }
        }

    }
}

数据库：

USE [Vegas]
GO
/****** 对象:  Table [dbo].[trvadmin]    脚本日期: 04/17/2008 16:26:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[trvadmin](
    [id] [int] NULL,
    [parentID] [int] NULL,
    [tableName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [url] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
    [target] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [expanded] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]