导航

.NET平台下Web树形结构程序设计

Posted on 2004-11-19 20:54  兰宝石.NET  阅读(261)  评论(0)    收藏  举报
李洪根 
CREATE TABLE [dbo].[tbTree] (
      [ID] [int] IDENTITY (1, 1) NOT NULL ,
      [Context] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
      [ParentID] [int] NULL 
) ON [PRIMARY]

SET IDENTITY_INSERT tbtree ON
insert tbtree (ID,Context,ParentID)  values ( 1,'中国',0)
insert tbtree (ID,Context,ParentID)  values ( 2,'北京',11)
insert tbtree (ID,Context,ParentID)  values ( 3,'天津',11)
insert tbtree (ID,Context,ParentID)  values ( 4,'河北省',1)
insert tbtree (ID,Context,ParentID)  values ( 5,'广东省',1)
insert tbtree (ID,Context,ParentID)  values ( 6,'广州',5)
insert tbtree (ID,Context,ParentID)  values ( 7,'四川省',1)
insert tbtree (ID,Context,ParentID)  values ( 8,'成都',7)
insert tbtree (ID,Context,ParentID)  values ( 9,'深圳',5)
insert tbtree (ID,Context,ParentID)  values ( 10,'石家庄',4)
insert tbtree (ID,Context,ParentID)  values ( 11,'辽宁省',1)
insert tbtree (ID,Context,ParentID)  values ( 12,'大连',11)
insert tbtree (ID,Context,ParentID)  values ( 13,'上海',1)
insert tbtree (ID,Context,ParentID)  values ( 14,'天河软件园',6)
insert tbtree (ID,Context,ParentID)  values ( 15,'汕头',5)
SET IDENTITY_INSERT tbtree off
<%@ Register TagPrefix="iewc" Namespace="Microsoft.Web.UI.WebControls" Assembly="Microsoft.Web.UI.WebControls, Version=1.0.2.226, Culture=neutral, PublicKeyToken=31bf3856ad364e35" %>
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="WebForm1.aspx.vb" Inherits="Tree.WebForm1"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>WebForm1</title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.0">
<meta name="CODE_LANGUAGE" content="Visual Basic 7.0">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<FONT face="宋体">
<iewc:TreeView id="TreeView1" style="Z-INDEX: 101; LEFT: 39px; TOP: 68px" runat="server"></iewc:TreeView></FONT>
</form>
</body>
</HTML>
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using Microsoft.Web.UI.WebControls;
using System.Data.SqlClient;
namespace TreeCS
{
      /// 
      /// WebForm1 的摘要说明
      /// 
      public class WebForm1 : System.Web.UI.Page
      {
            protected Microsoft.Web.UI.WebControls.TreeView TreeView1;
      
            private void Page_Load(object sender, System.EventArgs e)
            {
                  // 定义数据库连接
                  SqlConnection CN = new SqlConnection();
                  try 
                  {
                        //初始化连接字符串
                        CN.ConnectionString=
                        "data source=pmserver;initial catalog=Benchmark;persist security info=False;user id=sa;Password=sa;";
                        CN.Open();

                        SqlDataAdapter adp = new SqlDataAdapter("select * from tbTree",CN);
                        DataSet ds=new DataSet();
                        adp.Fill(ds);
                        this.ViewState["ds"]=ds; 
                  }
                  catch (Exception ex)
                  {
                        Session["Error"] = ex.ToString();
                        Response.Redirect("error.aspx");       //̀跳转程序的公共错误处理页面
                  }
                  finally 
                  {
                        CN.Close();
                  }
                  //调用递归函数，完成树形结构的生成
                  AddTree(0, (TreeNode)null);
            }

            //递归添加树的节点
            public void AddTree(int ParentID,TreeNode pNode) 
            {
                  DataSet ds=(DataSet) this.ViewState["ds"]; 
                  DataView dvTree = new DataView(ds.Tables[0]);
                  //过滤ParentID,得到当前的所有子节点
                  dvTree.RowFilter =  "[PARENTID] = " + ParentID;

                  foreach(DataRowView Row in dvTree) 
                  {
                        TreeNode Node=new TreeNode() ;
                        if(pNode == null) 
                        {    //添加根节点
                              Node.Text = Row["ConText"].ToString();
                              TreeView1.Nodes.Add(Node);
                              Node.Expanded=true;
                              AddTree(Int32.Parse(Row["ID"].ToString()), Node);    //再次递归
                        } 
                        else 
                        {   //̀添加当前节点的子节点
                              Node.Text = Row["ConText"].ToString();
                              pNode.Nodes.Add(Node);
                              Node.Expanded = true;
                              AddTree(Int32.Parse(Row["ID"].ToString()),Node);     //再次递归
                        }
                  }                   
            }            

            #region Web Form Designer generated code
            override protected void OnInit(EventArgs e)
            {
                  //
                  // CODEGEN该调用是 ASP.NET Web 窗体设计器所必需的。
                  //
                  InitializeComponent();
                  base.OnInit(e);
            }
            
            /// <summary>
            ///设计器支持所需的方法 - 不要使用代码编辑器修改
            /// 此方法的内容
            /// </summary>
            private void InitializeComponent()
            {    
                  this.Load += new System.EventHandler(this.Page_Load);

            }
            #endregion
      }
}