万能树状列表

lingjun1229 2008-03-11 10:55:04

using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlConnection conn = new SqlConnection("server=127.0.0.1;uid=sa;pwd=cuihufox;database=Text");
SqlDataAdapter sda = new SqlDataAdapter("select * from demo", conn);
DataSet ds = new DataSet();
sda.Fill(ds, "demo");
BindTreeView("default", ds.Tables["demo"]);
}
}

//邦定根节点
public void BindTreeView(string TargetFrame, DataTable dt)
{
DataRow[] drs = dt.Select("M_Id= " + 0);//　选出所有子节点

//菜单状态
bool menuExpand = false;

TreeView1.Nodes.Clear(); // 清空树

foreach (DataRow r in drs)//遍历节点,读取数据库对应字段
{
string nodeid = r["I_Id"].ToString();
string text = r["I_Name"].ToString();
string parentid = r["M_Id"].ToString();
string url = r["I_URl"].ToString();
string imageurl = r["I_Image"].ToString();
string framename = TargetFrame;
this.TreeView1.Font.Name = "宋体";
this.TreeView1.Font.Size = FontUnit.Parse("9");

TreeNode rootnode = new TreeNode();
rootnode.Text = text;
rootnode.Value = nodeid;
rootnode.NavigateUrl = url;
rootnode.Target = framename;
rootnode.Expanded = menuExpand;
rootnode.ImageUrl = imageurl;
rootnode.SelectAction = TreeNodeSelectAction.Expand;//和ASP.NET1.1中TREEVIEW的SelectExpands属性等效

TreeView1.Nodes.Add(rootnode);

int sonparentid = int.Parse(nodeid);// Ｏr =location
CreateNode(framename, sonparentid, rootnode, dt);

}

}

//邦定任意节点
public void CreateNode(string TargetFrame, int parentid, TreeNode parentnode, DataTable dt)
{

DataRow[] drs = dt.Select("M_Id= " + parentid);//选出所有子节点
foreach (DataRow r in drs)
{
string nodeid = r["I_Id"].ToString();
string text = r["I_Name"].ToString();
string url = r["I_URl"].ToString();
string imageurl = r["I_Image"].ToString();
string framename = TargetFrame;

TreeNode node = new TreeNode();
node.Text = text;
node.Value = nodeid;
node.NavigateUrl = url;
node.Target = TargetFrame;
node.ImageUrl = imageurl;
//node.Expanded=true;
node.SelectAction = TreeNodeSelectAction.Expand; //和ASP.NET1.1中TREEVIEW的SelectExpands属性等效
int sonparentid = int.Parse(nodeid);// Ｏr =location

if (parentnode == null)
{
TreeView1.Nodes.Clear();
parentnode = new TreeNode();
TreeView1.Nodes.Add(parentnode);
}
parentnode.ChildNodes.Add(node);
CreateNode(framename, sonparentid, node, dt);

}

}

}

...全文