首頁 > 開發者 > ASP

ASP.NET 遞迴演算法 產生N級（級聯）樹TreeView

來源：互聯網
上載者：User
創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

 

HTML代碼：

view plaincopy to clipboardprint?
<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %> 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml" > 
<head runat="server"> 
    <title>無標題頁</title> 
</head> 
<body> 
    <form id="form1" runat="server"> 
    <div> 
        <asp:TreeView ID="TreeView1" runat="server" Height="257px" ImageSet="WindowsHelp" 
          Width="142px"> 
            <ParentNodeStyle Font-Bold="False" /> 
            <HoverNodeStyle Font-Underline="True" ForeColor="#6666AA" /> 
            <SelectedNodeStyle BackColor="#B5B5B5" Font-Underline="False" HorizontalPadding="0px" 
                VerticalPadding="0px" /> 
            <NodeStyle Font-Names="Tahoma" Font-Size="8pt" ForeColor="Black" HorizontalPadding="5px" 
                NodeSpacing="0px" VerticalPadding="1px" /> 
        </asp:TreeView> 
          
      
    </div> 
    </form> 
</body> 
</html> 
<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>無標題頁</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:TreeView ID="TreeView1" runat="server" Height="257px" ImageSet="WindowsHelp"
          Width="142px">
            <ParentNodeStyle Font-Bold="False" />
            <HoverNodeStyle Font-Underline="True" ForeColor="#6666AA" />
            <SelectedNodeStyle BackColor="#B5B5B5" Font-Underline="False" HorizontalPadding="0px"
                VerticalPadding="0px" />
            <NodeStyle Font-Names="Tahoma" Font-Size="8pt" ForeColor="Black" HorizontalPadding="5px"
                NodeSpacing="0px" VerticalPadding="1px" />
        </asp:TreeView>
       
   
    </div>
    </form>
</body>
</html>
 

後台代碼：

view plaincopy to clipboardprint?
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 _Default : System.Web.UI.Page  
{  
    DataView dv;  
    DataTable dt;  
 
    protected void Page_Load(object sender, EventArgs e)  
    {  
 
        if (!Page.IsPostBack)  
        {  
    //資料庫執行查詢的方法就不寫了。  
            Operator op = new Operator();  
//這裡執行的是：select * from tabmenu  
            dt = op.Query();  
            //第一次載入時調用方法傳參   
            CreateTree(0, null, dt, this.TreeView1);  
            this.TreeView1.ExpandAll();  
        }  
    }  
 
    /// <summary>   
    /// 建立一個樹   
    /// </summary>   
    /// <param name="parentID">父ID</param>   
    /// <param name="node">節點</param>   
    /// <param name="dt">DataTable</param>   
    /// <param name="treeView">TreeView的名稱</param>   
    public void CreateTree(int parentID, TreeNode node, DataTable dt, TreeView treeView)  
    {  
        //執行個體化一個DataView dt = 傳入的DataTable   
        dv = new DataView(dt);  
        //篩選(相當於select * from tabMenu where menuParentID = 傳入的 parentID)   
        dv.RowFilter = "[menuParentID]=" + parentID;  
 
        //用foreach遍曆dv   
        foreach (DataRowView row in dv)  
        {  
            //第一次載入時為空白   
            if (node == null)  
            {  
                //建立根節點   
                TreeNode root = new TreeNode();  
                //必須與資料庫的對應   
                root.Text = row["menuName"].ToString();  
                root.Value = row["menuID"].ToString();  
                //添加根節點   
                this.TreeView1.Nodes.Add(root);  
                //遞迴調用方法本身   
                CreateTree(int.Parse(row["menuID"].ToString()), root, dt, treeView);  
 
            }  
            else 
            {  
                //添加子節點   
                TreeNode childNode = new TreeNode();  
                childNode.Text = row["menuName"].ToString();  
                childNode.Value = row["menuID"].ToString();  
                node.ChildNodes.Add(childNode);  
                CreateTree(int.Parse(row["menuID"].ToString()), childNode, dt, treeView);  
 
            }  
        }  
 
    }  
} 
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 _Default : System.Web.UI.Page
{
    DataView dv;
    DataTable dt;

    protected void Page_Load(object sender, EventArgs e)
    {

        if (!Page.IsPostBack)
        {
    //資料庫執行查詢的方法就不寫了。
            Operator op = new Operator();
//這裡執行的是：select * from tabmenu
            dt = op.Query();
            //第一次載入時調用方法傳參
            CreateTree(0, null, dt, this.TreeView1);
            this.TreeView1.ExpandAll();
        }
    }

    /// <summary>
    /// 建立一個樹
    /// </summary>
    /// <param name="parentID">父ID</param>
    /// <param name="node">節點</param>
    /// <param name="dt">DataTable</param>
    /// <param name="treeView">TreeView的名稱</param>
    public void CreateTree(int parentID, TreeNode node, DataTable dt, TreeView treeView)
    {
        //執行個體化一個DataView dt = 傳入的DataTable
        dv = new DataView(dt);
        //篩選(相當於select * from tabMenu where menuParentID = 傳入的 parentID)
        dv.RowFilter = "[menuParentID]=" + parentID;

        //用foreach遍曆dv
        foreach (DataRowView row in dv)
        {
            //第一次載入時為空白
            if (node == null)
            {
                //建立根節點
                TreeNode root = new TreeNode();
                //必須與資料庫的對應
                root.Text = row["menuName"].ToString();
                root.Value = row["menuID"].ToString();
                //添加根節點
                this.TreeView1.Nodes.Add(root);
                //遞迴調用方法本身
                CreateTree(int.Parse(row["menuID"].ToString()), root, dt, treeView);

            }
            else
            {
                //添加子節點
                TreeNode childNode = new TreeNode();
                childNode.Text = row["menuName"].ToString();
                childNode.Value = row["menuID"].ToString();
                node.ChildNodes.Add(childNode);
                CreateTree(int.Parse(row["menuID"].ToString()), childNode, dt, treeView);

            }
        }

    }
}
 

資料庫代碼：

view plaincopy to clipboardprint?
create table tabMenu  
(  
   menuID int identity(1,1) primary key,--自動編號  
   menuParentID int not null,--上級菜單的編號  
   menuName varchar(20) not null,--菜單名稱  
   menuUrl varchar(20) not null,--菜單地址  
   menuImage varchar(20) not null, --圖片地址  
   menuTarget varchar(20) not null,--開啟檔案  
)  
go  
--0表示根節點  
insert into tabMenu   
values(0,'xx後台管理','','','')  
 
--1子節點  
insert into tabMenu   
values(1,'學生管理','','','')  
 
insert into tabMenu   
values(1,'班級管理','','','')  
--2級節點  
insert into tabMenu   
values(2,'S1','','','')  
 
insert into tabMenu   
values(2,'S2','','','')  
 
insert into tabMenu   
values(2,'s3','','','')  
--3級節點  
 
insert into tabMenu   
values(3,'S1','','','')  
 
insert into tabMenu   
values(3,'S2','','','')  
 
insert into tabMenu   
values(3,'s3','','','')  
 
insert into tabMenu   
values(4,'Ccc','','','')  
 
insert into tabMenu   
values(5,'bbb,'','','')  
 
insert into tabMenu   
values(6,'fff','','','')  
--  
insert into tabMenu   
values(7,'stu1','','','')  
 
insert into tabMenu   
values(8,'stu2','','','')  
 
insert into tabMenu   
values(9,'stu1','','','')  
select * from tabMenu  
go 

 

 

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

聯繫我們

該頁面正文內容均來源於網絡整理，並不代表阿里雲官方的觀點，該頁面所提到的產品和服務也與阿里云無關，如果該頁面內容對您造成了困擾，歡迎寫郵件給我們，收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容，歡迎發送郵件至： info-contact@alibabacloud.com 進行舉報並提供相關證據，工作人員會在 5 個工作天內聯絡您，一經查實，本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More