asp.net TreeView控件绑定数据库显示信息
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>
奋斗就是每天很难,可是一年一年却越来越容易;
不奋斗就是每天很容易,可是一年一年却越来越难。