1 using System;
2 using System.Collections.Generic;
3 using System.Linq;
4 using System.Web;
5 using System.Web.UI;
6 using System.Web.UI.WebControls;
7 using System.Data;
8 using System.Data.SqlClient;
9 using System.Configuration;
10
11 public partial class _Default : System.Web.UI.Page
12 {
13 string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
14 protected void Page_Load(object sender, EventArgs e)
15 {
16 SqlConnection conn = new SqlConnection(constr);
17 conn.Open();
18 string sql="select * from student";
19 SqlDataAdapter da = new SqlDataAdapter(sql, conn);
20 DataSet ds = new DataSet();
21 da.Fill(ds,"student");
22 //下面的方法動态添加了treeView的根節點和子節點
23 TreeNode tree1 = new TreeNode("學生資訊");//設定根節點
24 this.TreeView1.Nodes.Add(tree1);
25 for (int i = 0; i < ds.Tables["student"].Rows.Count; i++)
26 {
27 TreeNode tree2 = new TreeNode(ds.Tables["student"].Rows[i][1].ToString(), ds.Tables["student"].Rows[i][1].ToString());
28 tree1.ChildNodes.Add(tree2);//顯示子節點
29 for (int j = 0; j < ds.Tables["student"].Columns.Count; j++)
30 {
31 TreeNode tree3 = new TreeNode(ds.Tables["student"].Rows[i][j].ToString(), ds.Tables["student"].Rows[i][j].ToString());
32 tree2.ChildNodes.Add(tree3);
33 }
34 }
35 }
36 public void BindDataBase()
37 {
38 BindDataBase();
39 TreeView1.ShowLines = true//顯示連接配接父節點與子節點間的線條;
40 TreeView1.ExpandDepth = 1;//控件顯示時所展開的層數
41 }
42 }
<configuration>
<connectionStrings>
<add name="constr" connectionString="server=.\sqlexpress;database=db2016;uid=sa;pwd=123;"/>
</connectionStrings>
<system.web>
<compilation debug="true" targetFramework="4.0" />
</system.web>
</configuration>
轉載于:https://www.cnblogs.com/luxiaoyao/p/6126567.html