treeview的所有生成语句都在这里: 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 xczwgl_treeview_dwbm : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) {
InitRoot(TreeView1); TreeView1.CollapseAll(); } } //treeview start-------------------------------------------------------------------------------------- //treeview start-------------------------------------------------------------------------------------- private DataSet CreateDataSet(string sqlstr) { try { string strconn = Session["MyConnectionString"].ToString(); SqlConnection myConn = new SqlConnection(strconn); myConn.Open(); SqlDataAdapter cd = new SqlDataAdapter(); cd.SelectCommand = new SqlCommand(sqlstr, myConn); cd.SelectCommand.CommandType = CommandType.Text; DataSet dsTree = new DataSet(); cd.Fill(dsTree, "dic_dqdm"); myConn.Close(); return dsTree; } catch { Console.WriteLine("Exception in Main :"); return null; } } private void InitRoot(TreeView Nds) { try { DataView dvTree = new DataView(); TreeNode tmpNd; string ls_parentcode; string ls_sql; if (Session["LoginDQDM"].ToString().Length <= 4) { ls_parentcode = Session["LoginDQDM"].ToString().Substring(0, Session["LoginDQDM"].ToString().Length - 2) + "00"; ls_sql = "select code,define,parentcode from dic_dqdm where code like '" + Session["LoginDQDM"].ToString() + "%' and parentcode like '" + ls_parentcode + "%'"; } else { //370101 县级单位 ls_parentcode = Session["LoginDQDM"].ToString().Substring(0, Session["LoginDQDM"].ToString().Length - 4) + "0000"; ls_sql = "select code,define,parentcode from dic_dqdm where code like '" + Session["LoginDQDM"].ToString().Substring(0, Session["LoginDQDM"].ToString().Length - 2) + "%' and parentcode like '" + ls_parentcode + "%'"; } DataSet ds = CreateDataSet(ls_sql); dvTree.Table = ds.Tables["dic_dqdm"]; foreach (DataRowView drvTree in dvTree) { tmpNd = new TreeNode(); tmpNd.Value = drvTree["code"].ToString(); tmpNd.Text = drvTree["define"].ToString(); Nds.Nodes.Add(tmpNd); //if drvTree.Row.ToString tmpNd.PopulateOnDemand = true; tmpNd.SelectAction = TreeNodeSelectAction.Expand; } } catch { // } } private void AddChild(TreeNode tnd) { try { DataView dvTree = new DataView(); TreeNode tmpNd; DataSet ds = CreateDataSet("select code,define,parentcode from dic_dqdm where code like '" + Session["LoginDQDM"].ToString() + "%' and parentcode = '" + tnd.Value.ToString() + "'"); dvTree.Table = ds.Tables["dic_dqdm"]; dvTree.RowFilter = "parentcode='" + tnd.Value.ToString() + "'"; foreach (DataRowView drvTree in dvTree) { tmpNd = new TreeNode(); tmpNd.Value = drvTree["code"].ToString(); tmpNd.Text = drvTree["define"].ToString(); tnd.ChildNodes.Add(tmpNd); tmpNd.PopulateOnDemand = true; } if (tnd.ChildNodes.Count != 0) tnd.SelectAction = TreeNodeSelectAction.Expand; } catch { // } } protected void TreeView1_TreeNodePopulate(object sender, TreeNodeEventArgs e) { AddChild(e.Node); } protected void TreeView1_SelectedNodeChanged1(object sender, EventArgs e) { TextBox_dwmc.Text = TreeView1.SelectedNode.Text; TextBox_dwbm.Text = TreeView1.SelectedNode.Value; } //treeview end -------------------------------------------------------------------------------------- //treeview end -------------------------------------------------------------------------------------- }
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 xczwgl_treeview_dwbm : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
InitRoot(TreeView1);
TreeView1.CollapseAll();
}
}
//treeview start--------------------------------------------------------------------------------------
//treeview start--------------------------------------------------------------------------------------
private DataSet CreateDataSet(string sqlstr)
{
try
{
string strconn = Session["MyConnectionString"].ToString();
SqlConnection myConn = new SqlConnection(strconn);
myConn.Open(); SqlDataAdapter cd = new SqlDataAdapter();
cd.SelectCommand = new SqlCommand(sqlstr, myConn);
cd.SelectCommand.CommandType = CommandType.Text; DataSet dsTree = new DataSet();
cd.Fill(dsTree, "dic_dqdm");
myConn.Close();
return dsTree;
}
catch
{
Console.WriteLine("Exception in Main :");
return null;
}
} private void InitRoot(TreeView Nds)
{
try
{
DataView dvTree = new DataView();
TreeNode tmpNd;
string ls_parentcode;
string ls_sql;
if (Session["LoginDQDM"].ToString().Length <= 4)
{
ls_parentcode = Session["LoginDQDM"].ToString().Substring(0, Session["LoginDQDM"].ToString().Length - 2) + "00";
ls_sql = "select code,define,parentcode from dic_dqdm where code like '" + Session["LoginDQDM"].ToString() + "%' and parentcode like '" + ls_parentcode + "%'";
}
else
{
//370101 县级单位
ls_parentcode = Session["LoginDQDM"].ToString().Substring(0, Session["LoginDQDM"].ToString().Length - 4) + "0000";
ls_sql = "select code,define,parentcode from dic_dqdm where code like '" + Session["LoginDQDM"].ToString().Substring(0, Session["LoginDQDM"].ToString().Length - 2) + "%' and parentcode like '" + ls_parentcode + "%'"; }
DataSet ds = CreateDataSet(ls_sql); dvTree.Table = ds.Tables["dic_dqdm"];
foreach (DataRowView drvTree in dvTree)
{
tmpNd = new TreeNode();
tmpNd.Value = drvTree["code"].ToString();
tmpNd.Text = drvTree["define"].ToString();
Nds.Nodes.Add(tmpNd);
//if drvTree.Row.ToString
tmpNd.PopulateOnDemand = true;
tmpNd.SelectAction = TreeNodeSelectAction.Expand; }
}
catch
{
//
}
}
private void AddChild(TreeNode tnd)
{
try
{
DataView dvTree = new DataView();
TreeNode tmpNd; DataSet ds = CreateDataSet("select code,define,parentcode from dic_dqdm where code like '" + Session["LoginDQDM"].ToString() + "%' and parentcode = '" + tnd.Value.ToString() + "'");
dvTree.Table = ds.Tables["dic_dqdm"];
dvTree.RowFilter = "parentcode='" + tnd.Value.ToString() + "'";
foreach (DataRowView drvTree in dvTree)
{
tmpNd = new TreeNode();
tmpNd.Value = drvTree["code"].ToString();
tmpNd.Text = drvTree["define"].ToString();
tnd.ChildNodes.Add(tmpNd);
tmpNd.PopulateOnDemand = true;
}
if (tnd.ChildNodes.Count != 0)
tnd.SelectAction = TreeNodeSelectAction.Expand;
}
catch
{
//
}
} protected void TreeView1_TreeNodePopulate(object sender, TreeNodeEventArgs e)
{
AddChild(e.Node);
} protected void TreeView1_SelectedNodeChanged1(object sender, EventArgs e)
{
TextBox_dwmc.Text = TreeView1.SelectedNode.Text;
TextBox_dwbm.Text = TreeView1.SelectedNode.Value;
} //treeview end --------------------------------------------------------------------------------------
//treeview end --------------------------------------------------------------------------------------
}
这里面有用ajax方法删除节点的例子,lz要实现的比这个要简单吧