tree.aspx.cs
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 My_Class;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
My_Class.Arr bmArray = new Arr();
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
AddDynamicItems();//画树
}
}
#region //画树
private void AddDynamicItems()//画树
{
SqlConnection myconn = new SqlConnection();
myconn.ConnectionString = System.Configuration.ConfigurationManager.AppSettings["sqlserver"];
myconn.Open();
SqlCommand cmd = myconn.CreateCommand();
SqlDataReader rec = null;
cmd.CommandText = "select dwbm,dwmc,sjdwbm from TREE order by dwbm";
rec = cmd.ExecuteReader();
while (rec.Read())
{
bmArray.Add(rec["dwbm"].ToString(), rec["dwmc"].ToString(), rec["sjdwbm"].ToString());
}
rec.Close();
cmd.CommandText = "select dwbm,dwmc from TREE where sjdwbm is null order by dwbm";
rec = cmd.ExecuteReader();
Microsoft.Web.UI.WebControls.TreeNode newNode = null;
while (rec.Read())
{
newNode = new Microsoft.Web.UI.WebControls.TreeNode();
newNode.Text = rec["dwmc"].ToString() + rec["dwbm"].ToString();
newNode.NodeData = rec["dwbm"].ToString();
DrawcomTree(rec["dwbm"].ToString(), newNode);
my_tree.Nodes.Add(newNode);
}
rec.Close();
cmd.Dispose();
myconn.Close();
myconn.Dispose();
}
private void DrawcomTree(string dwbm, Microsoft.Web.UI.WebControls.TreeNode treeNode)//画树的递归函数
{
Microsoft.Web.UI.WebControls.TreeNode childNode;
for (int i = 0; i < bmArray.Count; i++)
{
if (bmArray.getSjbm(i).ToString() == dwbm)
{
childNode = new Microsoft.Web.UI.WebControls.TreeNode();
childNode.Text = "(" + bmArray.getBm(i).ToString() + ")" + bmArray.getMc(i).ToString();
childNode.NodeData = bmArray.getBm(i).ToString();
treeNode.Nodes.Add(childNode);
//treeNode.Expanded =true;
DrawcomTree(bmArray.getBm(i).ToString(), childNode);
}
}
}
#endregion
}
Tree.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="tree.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="Microsoft.Web.UI.WebControls" Namespace="Microsoft.Web.UI.WebControls"
TagPrefix="iewc" %>
<!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>
<iewc:TreeView ID="my_tree" runat="server" SystemImagesPath="webctrl_client/1_0/treeimages/"></iewc:TreeView></div>
</form>
</body>
</html>
http://hi.baidu.com/jilijun/blog/item/b359e73df0147cc69e3d6249.html