Asp.net 2.0 Treeview 动态填充,并实现无限级树
Asp.net 2.0 Treeview 动态填充,并实现无限级树,
数据库表关键字段:
表: table1
type_id type_name per_type_id
0 根目录 -1
1 子目录 0
2 子目录2 0
3 子子目录 2
.
9 根目录二 -1
C#代码
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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.Data.SqlClient;
public partial class tree : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
TreeView1.Nodes.Clear();
DataTable dt = tree_table();
DataView dv = new DataView(dt);
dv.RowFilter = "type_id = 0";
foreach (DataRowView drv in dv)
{
TreeNode node = new TreeNode();
node.Text = drv["type_name"].ToString();
node.Value = drv["type_id"].ToString();
node.NavigateUrl = "?s=" + drv["type_id"].ToString();
TreeView1.Nodes.Add(node);
AddChildNode(dt, node);
}
}
private DataTable tree_table()
{
//hooyesDataLink 为配置中数据连接字符串键名
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["hooyesDataLink"]);
SqlDataAdapter sda = new SqlDataAdapter("select * from table1", con);
DataTable dt = new DataTable();
sda.Fill(dt);
return dt;
}
递归以实现无限级树
}
效果:
数据库表关键字段:
表: table1
type_id type_name per_type_id 0 根目录 -1 1 子目录 0 2 子目录2 0 3 子子目录 2 . 9 根目录二 -1C#代码
using System;using System.Data;using System.Configuration;using System.Collections;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.Data.SqlClient;public partial class tree : System.Web.UI.Page{
protected void Page_Load(object sender, EventArgs e) { TreeView1.Nodes.Clear(); DataTable dt = tree_table(); DataView dv = new DataView(dt); dv.RowFilter = "type_id = 0"; foreach (DataRowView drv in dv) { TreeNode node = new TreeNode(); node.Text = drv["type_name"].ToString(); node.Value = drv["type_id"].ToString(); node.NavigateUrl = "?s=" + drv["type_id"].ToString(); TreeView1.Nodes.Add(node); AddChildNode(dt, node); } } private DataTable tree_table() { //hooyesDataLink 为配置中数据连接字符串键名 SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["hooyesDataLink"]); SqlDataAdapter sda = new SqlDataAdapter("select * from table1", con); DataTable dt = new DataTable(); sda.Fill(dt); return dt; } 递归以实现无限级树}效果:
