• 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>

  • 相关阅读:
    Live2D 看板娘
    Live2D 看板娘
    Live2D 看板娘
    Live2D 看板娘
    Live2D 看板娘
    Live2D 看板娘
    Live2D 看板娘
    Live2D 看板娘
    Live2D 看板娘
    重读《深入理解Java虚拟机》三、Java虚拟机执行的数据入口(类文件结构)
  • 原文地址:https://www.cnblogs.com/luxiaoyao/p/6126567.html
Copyright © 2020-2023  润新知