后台代码部分:
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.IO;
using System.Net;
using System.Text;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PopulateNodes(TreeView1.Nodes, 0);
}//
}
public DataTable GetTreeTable()
{
DataTable dt = new DataTable();
dt = HttpContext.Current.Cache["Treeview"] as DataTable;
if (dt != null)
{
//此处是数据库连接
//String ConnStr = LTP.Common.ConfigHelper.GetConfigString("DNS");
String ConnStr = ConfigurationManager.ConnectionStrings["DNS"].ConnectionString;
SqlConnection Conn = new SqlConnection(ConnStr);
//String sqlstr = "select * from TreeJi";
SqlCommand Com = new SqlCommand();
Com.CommandText = "select * from TreeJi";
Com.Connection = Conn;
Conn.Open();
Com.ExecuteNonQuery();
SqlDataAdapter sda = new SqlDataAdapter(Com);
dt = new DataTable();
sda.Fill(dt);
HttpContext.Current.Cache.Insert("Treeview", dt);
Conn.Close();
Conn.Dispose();
}
return dt;
}
public void PopulateNodes(TreeNodeCollection nodes, Int32 intParentID)
{
DataTable dt = new DataTable();
dt = this.GetTreeTable();
String strExpression = String.Empty;
strExpression = "[parentID]=" + intParentID;
System.Data.DataRow[] dr;
dr = dt.Select(strExpression);
for (Int32 i = 0; i <= dr.GetUpperBound(0); i++)
{
TreeNode tn = new TreeNode(); //Dim tn As New TreeNode()
tn.Text = dr
["TableName"].ToString().Trim();//tn.Text = foundRows(I).Item(“TableName”).ToString()
tn.Value = dr["ID"].ToString(); //tn.Value = foundRows(I).Item("ID").ToString()
DataRow[] dr1; //Dim dr() As DataRow
dr1 = dt.Select("[parentID]=" + tn.Value); //dr = dt.Select("[parentID] = " & tn.Value)
if (dr1.GetUpperBound(0) > -1)
{
tn.PopulateOnDemand = true;
}//If dr.GetUpperBound(0) > -1 Then
// tn.PopulateOnDemand = True
//End If
nodes.Add(tn);
}
//TreeView1.DataSource = dt.DefaultView;
//TreeView1.DataBind();
}
protected void TreeView1_TreeNodePopulate(object sender, TreeNodeEventArgs e)
{
PopulateNodes(e.Node.ChildNodes, Int32.Parse(e.Node.Value));
}
}
前台页面部分:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!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>
<asp:TreeView ID="TreeView1" runat="server" OnTreeNodePopulate="TreeView1_TreeNodePopulate">
</asp:TreeView>
</div>
</form>
</body>
</html>
tlbb225 于 2010-09-05 07:27 AM 发表评论：
