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;
public partial class treeview树形菜单_Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//value="server=60.191.135.155;database=sowdotest;uid=sa;pwd=sowdosql2008"/>
// 定义数据库连接
SqlConnection CN = new SqlConnection();
try
{
// 初始化连接字符串
CN.ConnectionString = "server=60.12.125.155;database=ceshi;uid=21;pwd=s1w12008";
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 Node1 = new TreeNode();
if (pNode == null)
{ //添加根节点
Node1.Text = Row["ConText"].ToString();
TreeView1.Nodes.Add(Node1);
Node1.Expanded = true;
Node1.NavigateUrl = "#";
AddTree(Int32.Parse(Row["ID"].ToString()), Node1); //再次递归
}
else
{ //̀添加当前节点的子节点
Node1.Text = Row["ConText"].ToString();
pNode.ChildNodes.Add(Node1);
Node1.Expanded = true;
Node1.NavigateUrl = "#";
AddTree(Int32.Parse(Row["ID"].ToString()), Node1); //再次递归
}
}
}
}
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;
public partial class treeview树形菜单_Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//value="server=60.191.135.155;database=sowdotest;uid=sa;pwd=sowdosql2008"/>
// 定义数据库连接
SqlConnection CN = new SqlConnection();
try
{
// 初始化连接字符串
CN.ConnectionString = "server=60.12.125.155;database=ceshi;uid=21;pwd=s1w12008";
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 Node1 = new TreeNode();
if (pNode == null)
{ //添加根节点
Node1.Text = Row["ConText"].ToString();
TreeView1.Nodes.Add(Node1);
Node1.Expanded = true;
Node1.NavigateUrl = "#";
AddTree(Int32.Parse(Row["ID"].ToString()), Node1); //再次递归
}
else
{ //̀添加当前节点的子节点
Node1.Text = Row["ConText"].ToString();
pNode.ChildNodes.Add(Node1);
Node1.Expanded = true;
Node1.NavigateUrl = "#";
AddTree(Int32.Parse(Row["ID"].ToString()), Node1); //再次递归
}
}
}
}