Question

ASP.NET中怎么使用树形控件绑定从数据库读取的数据?

Answer 1

create database TreeView
go
use Treeview

create table node1
(
nd1id int primary key,
nd1name varchar(32)
)

create table node2
(
nd2id int primary key,
nd1id int,
nd2name varchar(32)
)

create table node3
(
nd3id int primary key,
nd2id int,
nd3name varchar(32)
)

insert node1 values(0,'node1_1')
insert node1 values(1,'node1_2')
insert node1 values(2,'node1_3')
insert node1 values(3,'node1_4')
insert node2 values(0,0,'node2_1')
insert node2 values(1,0,'node2_2')
insert node2 values(2,1,'node2_3')
insert node2 values(3,1,'node2_4')
insert node2 values(4,2,'node2_5')
insert node2 values(5,3,'node2_6')
insert node2 values(6,2,'node2_7')

insert node3 values(0,0,'node3_1')
insert node3 values(1,0,'node3_2')
insert node3 values(2,1,'node3_3')
insert node3 values(3,2,'node3_4')
insert node3 values(4,1,'node3_5')
insert node3 values(5,3,'node3_6')
insert node3 values(6,5,'node3_7')
insert node3 values(7,6,'node3_8')
insert node3 values(8,3,'node3_9')
insert node3 values(9,4,'node3_10')
insert node3 values(10,5,'node3_11')

VS代码

void PopulateCategories(TreeNode node)
�0�2 {
�0�2 string sql = "Select nd1name, nd1id From node1";
�0�2 DataSet resultSet;
�0�2 resultSet = Getdataset(sql, null);
�0�2 if (resultSet.Tables.Count > 0)
�0�2 {
�0�2 foreach (DataRow row in resultSet.Tables[0].Rows)
�0�2 {
�0�2 TreeNode NewNode = new TreeNode(row["nd1name"].ToString(), row["nd1id"].ToString());
�0�2 NewNode.PopulateOnDemand = true;
�0�2 NewNode.SelectAction = TreeNodeSelectAction.Expand;
�0�2 node.ChildNodes.Add(NewNode);
�0�2 }
�0�2 }
�0�2 }

�0�2 void PopulateProducts(TreeNode node)
�0�2 {

�0�2 string sql = "Select nd2name,nd2id From node2 " + " Where nd1id = @id";
�0�2 SqlParameter para = new SqlParameter("@id", SqlDbType.Int);
�0�2 para.Value = node.Value;
�0�2 //sqlQuery.Parameters.Add("@id", SqlDbType.Int).Value = node.Value;
�0�2 DataSet ResultSet = Getdataset(sql, para);
�0�2 if (ResultSet.Tables.Count > 0)
�0�2 {
�0�2 foreach (DataRow row in ResultSet.Tables[0].Rows)
�0�2 {
�0�2 TreeNode NewNode = new TreeNode(row["nd2name"].ToString(), row["nd2id"].ToString());
�0�2 NewNode.PopulateOnDemand = true;
�0�2 NewNode.SelectAction = TreeNodeSelectAction.Expand;
�0�2 node.ChildNodes.Add(NewNode);
�0�2 }
�0�2 }
�0�2 }

�0�2 void PopulateProducts1(TreeNode node)
�0�2 {

�0�2 string sql = "Select nd3name,nd3id From node3 " + " Where nd2id = @id";
�0�2 SqlParameter para = new SqlParameter("@id", SqlDbType.Int);
�0�2 para.Value = node.Value;
�0�2 //sqlQuery.Parameters.Add("@id", SqlDbType.Int).Value = node.Value;
�0�2 DataSet ResultSet = Getdataset(sql, para);
�0�2 if (ResultSet.Tables.Count > 0)
�0�2 {
�0�2 foreach (DataRow row in ResultSet.Tables[0].Rows)
�0�2 {
�0�2 TreeNode NewNode = new TreeNode(row["nd3name"].ToString(), row["nd3id"].ToString());
�0�2 NewNode.PopulateOnDemand = false;
�0�2 NewNode.SelectAction = TreeNodeSelectAction.SelectExpand;
�0�2 node.ChildNodes.Add(NewNode);
�0�2 }
�0�2 }
�0�2 }

�0�2 private DataSet Getdataset(string sql,SqlParameter paralist)
�0�2 {
�0�2 string strconn = "database=treeview;server=.;Integrated Security=SSPI";
�0�2 SqlConnection conn = new SqlConnection(strconn);
�0�2 SqlCommand cmd = new SqlCommand();
�0�2 if (paralist != null)
�0�2 {

�0�2 cmd.Parameters.Add(paralist);
�0�2 �0�2
�0�2 }
�0�2 cmd.CommandText = sql;
�0�2 cmd.Connection = conn;
�0�2 SqlDataAdapter da = new SqlDataAdapter(cmd);
�0�2 DataSet ds = new DataSet();
�0�2 da.Fill(ds);
�0�2 return ds;
�0�2 }

�0�2 protected void TreeView1_TreeNodePopulate(object sender, TreeNodeEventArgs e)
�0�2 {
�0�2 if (e.Node.ChildNodes.Count == 0)
�0�2 {
�0�2 switch (e.Node.Depth)
�0�2 {
�0�2 case 0:
�0�2 PopulateCategories(e.Node);
�0�2 break;
�0�2 case 1:
�0�2 PopulateProducts(e.Node);
�0�2 break;
�0�2 case 2:
�0�2 PopulateProducts1(e.Node);
�0�2 break;
�0�2 �0�2
�0�2 �0�2
�0�2 }
�0�2 }
�0�2 }

�0�2 protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
�0�2 {
�0�2 Response.Write("adfdf");

�0�2 }
�0�2 protected void TreeView1_TreeNodeExpanded(object sender, TreeNodeEventArgs e)
�0�2 {
�0�2 //Response.Write("adfdf");
�0�2 }