ASP.NET TreeView显示分类_treeview 指定类型显示-优快云博客

本文介绍如何在 ASP.NET 应用中使用 TreeView 控件实现目录结构展示，并通过数据库存储目录信息，利用 C# 实现递归加载目录结构。

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

数据库表
TreeViews

id              int类型主键自动增长
name     目录名称
pid           父目录id
urlPath    url路径

效果图

aspx页面文件放一个treeview控件

<body>
     <form id="form1" runat="server">
     <div>
         <br />
         <asp:TreeView ID="TreeView1" runat="server">
            </asp:TreeView>
     </div>
    </form>
--------------------------------------------------------------------------------------------------------------------------------
aspx.cs文件内容:

using System;
using System.Data;
using System.Configuration;
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.Collections;
using System.Collections.Generic;
using web.DAL; //添加的引用项目内部的
using web.Model;//实体

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

     }

     protected void tree()
     {

          TreeNode node = new TreeNode();     //初始化根目录
          node.Text = "根目录";
          addnode(0)//0为根节点

          TreeView1.Nodes.Add(node); //添加根目录到treeview控件

         }
      private void addNode(int NodeId)

{

List<TreeViews> list = TreeViewManager.getTvById(NodeId); //查询节点下的节点

                foreach (TreeViews tv in list)
                {
                    TreeNode node = new TreeNode();
                    node.Text = tv.Name;                          ////节点名称
                    node.NavigateUrl = tv.UrlPath;             ////节点路径
                    node.ChildNodes.Add(node);

addNode(tv.Id) //递归添加节点

}

     }

}

---------------------------------------------------------------------------------------------------------------------------------

web.DAL的TreeViewManager.cs类文件

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Data.Sql;
using web.Model;
namespace web.DAL
{
     public class TreeViewManager
     {
         public static List<TreeViews> getTvById(int id)
         {
             string sql = "select * from Treeviews where  ORDER BY Id asc ";
             SqlParameter [] values={
                 new SqlParameter("@id",id)
             };
             List<TreeViews> list = getDataTable(sql, values);
             return list;

}

         private static List<TreeViews> getDataTable(string sql,SqlParameter [] values)
         {

              using (DataTable dt = DBHelper.GetDataTable(sql, values))
              {
                  List<TreeViews> list = new List<TreeViews>();
                 foreach (DataRow row in dt.Rows)
                 {
                     TreeViews tv = new TreeViews();
                     tv.Id =(int) row["id"];
                     tv.Name = row["name"].ToString();
                     tv.PId=(int)row["pid"];
                     tv.UrlPath = row["UrlPath"].ToString();
                     list.Add(tv);
                 }
                 return list;

             }
         }
     }
}
-------------------------------------------------------------------------------------------------------------------------------

DBHelper.cs类访问数据库的
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;

namespace web.DAL
{
     public class DBHelper
     {
         private static readonly string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;    //获取web.config的网站的数据库.账号.密码

         private static SqlConnection CreateConnection()//创建连接数据库
         {
             SqlConnection conn = new SqlConnection(constr);
             if (conn.State==ConnectionState.Closed)
             {
                 conn.Open();
                 return conn;
             }
             else
             {
                 return conn;
             }
         }

//执行增删改的.不过在本项目中没有用到
         public static int ExcuteCommand(string sql, SqlParameter[] values)
     {
             int i = 0;
             using (SqlConnection conn = CreateConnection())
             {
                 SqlCommand comd = new SqlCommand(sql, conn);
                 if (values != null)
                 {
                     comd.Parameters.AddRange(values);
                 }
                 i = comd.ExecuteNonQuery();
                 return i;
             }
         }
//执行读取的.不过在本项目中没有用到

         public static SqlDataReader GetReader(string sql,SqlParameter [] values)
         {
                  SqlConnection conn = CreateConnection();

                 SqlCommand comd = new SqlCommand(sql,conn);
                 if (values != null)
                 {
                     comd.Parameters.AddRange(values);
                 }
                 SqlDataReader rd = comd.ExecuteReader(CommandBehavior.CloseConnection);
                 return rd;

         }
//返回DataSet的.不过在本项目中没有用到

         public static DataSet GetDateSet(string sql,SqlParameter [] values)
         {
             using(SqlConnection conn=CreateConnection())
             {
                 SqlDataAdapter ap = new SqlDataAdapter(sql, conn);
                 DataSet ds = new DataSet();
                 if (values != null)
                     ap.SelectCommand.Parameters.AddRange(values);
                 ap.Fill(ds);
                 return ds;
             }

         }
//返回DataTable表主要用这个了
         public static DataTable GetDataTable(string sql,SqlParameter [] values)
         {
             using (SqlConnection conn = CreateConnection())
             {
                 SqlDataAdapter ap = new SqlDataAdapter(sql, conn);
                 DataTable dt = new DataTable();
                 if (values != null)
                 {
                     ap.SelectCommand.Parameters.AddRange(values);
                 }
                 ap.Fill(dt);
                 return dt;
             }
         }

}
}
------------------------------------------------------------------------------------------------------------------------
Treeviews.cs实体类
using System;
using System.Collections.Generic;
using System.Text;

namespace web.Model
{
     public class TreeViews
     {
         int id;
         string name;
         int pId;
         string urlPath;

public TreeViews() { }

         public string UrlPath
         {
             get { return urlPath; }
             set { urlPath = value; }
         }

         public int PId
         {
             get { return pId; }
             set { pId = value; }
         }

         public string Name
         {
             get { return name; }
             set { name = value; }
         }

         public int Id
         {
             get { return id; }
             set { id = value; }
         }

}
}

注:因为中间层没什么东西.就省略了.直接用的DAL层的.