asp.net TreeView控制項綁定資料庫顯示資訊

標籤：exp   this   class   open   apt   lines   lex   expr   .config   

 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.Page12 {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>

 

asp.net TreeView控制項綁定資料庫顯示資訊