asp.net 2.0 中递归树的实现

最新推荐文章于 2019-02-15 21:52:00 发布

原创最新推荐文章于 2019-02-15 21:52:00 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#asp.net #server #dataset #string #exception #html

asp.net 2.0 专栏收录该内容

5 篇文章

订阅专栏

本文介绍如何使用 ASP.NET 中的 TreeView 控件来构建动态的树形导航菜单。通过连接数据库并递归地填充节点，实现了从数据库中读取多级结构的数据并展示为树形结构的功能。

HTML页面：

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="TreeView.aspx.vb" Inherits="TreeView" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<div>

<asp:TreeView ID="TreeView1" runat="server" ExpandDepth="1" Font-Size="9pt" AutoGenerateDataBindings="False" EnableTheming="True" NodeWrap="True" ShowLines="True" Target="_blank">

</asp:TreeView>

</div>

</form>

</body>

</html>

后台CS代码：

Imports System.Web

Imports System.Data.SqlClient

Imports System.Data

Partial Class TreeView

Inherits System.Web.UI.Page

Dim ds As DataSet = New System.Data.DataSet()

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If Not IsPostBack Then

Dim sqlstr As String = "select a.*,T32003.T3200303 as orderProgramID from(select 项目代码 as nodeID,项目名称 as nodeName,项目名称 as parentID from acf_v_lefttree_Admin where 项目代码<>' ' and 项目代码 is not null group by 项目代码,项目名称 union all select 系统代码 as nodeID,系统名称 as nodeName,项目代码 as parentID from acf_v_lefttree_Admin where 系统代码<>' ' and 系统代码 is not null group by 项目代码,系统代码,系统名称 union all select 子系统代码 as nodeID,子系统名称 as nodeName,系统代码 as parentID from acf_v_lefttree_Admin where 子系统代码<>' ' and 子系统代码 is not null group by 系统代码,子系统代码,子系统名称 union all select 程式代码 as nodeID,程式名称 as nodeName,子系统代码 as parentID from acf_v_lefttree_Admin where 程式代码<>' ' and 程式代码 is not null group by 子系统代码,程式代码,程式名称 ) a left outer join T32003 on a.nodeID = T32003.T3200301"

Dim conn As SqlConnection = New SqlConnection("server=(local);database=acfv3;uid=sa;pwd=888888")

Dim sqlada As SqlDataAdapter = New SqlDataAdapter(sqlstr, conn)

sqlada.Fill(ds, "TreeTb")

createtree(TreeView1.Nodes, "我的ACF")

End If