主页 > 编程资料 > C# >
发布时间:2015-09-26 作者:网络 阅读:177次
网站目录下需要有Microsoft.Web.UI.WebControls.dll和相应的文件
如大家要转载,请保留本人的版权。

/*
*Description:完全的操作XML文件
*Auther:mingziweb_天很蓝
*Email:chongchong2008@msn.com
*Dates:22004-09-10
*Copyright:ChongChong2008 YiChang HuBei China
*/



.aspx
<%@ Register TagPrefix="ie" Namespace="Microsoft.Web.UI.WebControls" Assembly="Microsoft.Web.UI.WebControls" %>
<%@ Page language="c#" Codebehind="TreeView.aspx.cs" AutoEventWireup="false" Inherits="Test.WebForm1" %>



WebForm1








runat="server">







.cs
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 System.Data.SqlClient;
using System.Configuration;

using Microsoft.Web.UI.WebControls;

namespace Test
{
///
/// WebForm1 的摘要说明。
///

public class WebForm1 : System.Web.UI.Page
{
protected Microsoft.Web.UI.WebControls.TreeView myTreeView;

private SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);



#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}

///
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
///

private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion





private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面

TreeNode myTreeNodeRoot = AddTreeNodeRoot();
AppendChild(myTreeNodeRoot);

}





private TreeNode AddTreeNodeRoot()
{

TreeNode myTreeNode = new TreeNode();

myTreeNode.ID = "420000";
myTreeNode.Expanded = true;
myTreeNode.Target = "";
myTreeNode.Text = "我的社区";

myTreeView.Nodes.Add(myTreeNode);
return myTreeNode;
}



private TreeNode AddSubNode(TreeNode subTreeNode)
{

TreeNode myTreeNode = new TreeNode();

myTreeNode.ID = "00001";
myTreeNode.Expanded = true;
myTreeNode.Target = "";
myTreeNode.Text = "省份";
myTreeNode.NavigateUrl = "" ;

subTreeNode.Nodes.Add(myTreeNode);
return myTreeNode;
}





private void AppendChild(TreeNode myTreeNode)
{

TreeNode mySubNode = AddSubNode(myTreeNode);

if(GetClassTable().Rows.Count>0)
{
DataTable myDataTable = new DataTable();
myDataTable = GetClassTable();

for(int i=0;i{
TreeNode myTreeNodeSub = new TreeNode();

myTreeNodeSub.CheckBox=true;
if(i==20)
{
myTreeNodeSub.Checked=true;

}

myTreeNodeSub.ID = myDataTable.Rows[i]["class_code"].ToString();
myTreeNodeSub.Expanded = false;
myTreeNodeSub.Target = "Body";
myTreeNodeSub.Text = myDataTable.Rows[i]["class_name"].ToString();
myTreeNodeSub.NavigateUrl = "DocList.aspx?DocCatalogGuid=" + myDataTable.Rows[i]["class_code"].ToString();

mySubNode.Nodes.Add(myTreeNodeSub);

AppendChildren(myTreeNodeSub);

}
}
}




private void AppendChildren(TreeNode myTreeNode)
{
if(GetSubClassTable(myTreeNode.ID).Rows.Count>0)
{
DataTable myDataTable = new DataTable();
myDataTable = GetSubClassTable(myTreeNode.ID);

for(int i=0;i{
TreeNode myTreeNodeSub = new TreeNode();

myTreeNodeSub.CheckBox=true;


myTreeNodeSub.ID = myDataTable.Rows[i]["subclass_code"].ToString();
myTreeNodeSub.Expanded = false;
myTreeNodeSub.Target = "Body";
myTreeNodeSub.Text = myDataTable.Rows[i]["subclass_name"].ToString();
myTreeNodeSub.NavigateUrl = "DocList.aspx?DocCatalogGuid=" + myDataTable.Rows[i]["class_code"].ToString();

myTreeNode.Nodes.Add(myTreeNodeSub);

AppendChildren(myTreeNodeSub);

}
}
}





private DataTable GetClassTable()
{
//绑定drpMC_Code

string strSql="select * from [class] order by id desc";

OpenConnection();

SqlDataAdapter myCommand = new SqlDataAdapter(strSql,myConnection);
DataSet ds= new DataSet();
myCommand.Fill(ds);

CloseConnection();

return ds.Tables[0];

}




private DataTable GetSubClassTable(string class_code)
{
//绑定drpMC_Code

string strSql="select * from [subclass] where class_code=@class_code order by id desc";

OpenConnection();


SqlDataAdapter myCommand = new SqlDataAdapter(strSql,myConnection);

myCommand.SelectCommand.CommandType=CommandType.Text;
myCommand.SelectCommand.Parameters.Add("@class_code",SqlDbType.NVarChar,10).Value=class_code
;
DataSet ds= new DataSet();
myCommand.Fill(ds);

CloseConnection();

return ds.Tables[0];

}




///
/// 打开数据库连接
///


private void OpenConnection()
{

if (myConnection.State == ConnectionState.Closed)
myConnection.Open();

}





///
/// 关闭数据库连接
///


private void CloseConnection()
{

if (myConnection.State == ConnectionState.Open)
myConnection.Close();

}







}
}
关键字词: