TreeView使用示例

 

 public void genNodes() {//产生树形节点，并展开
            this.treeView1.Nodes[0].Nodes.Clear();//清空0号节点

            SqlConnection sqlConn = new SqlConnection();
            sqlConn.ConnectionString = @"Data Source=S1-023;Initial Catalog=student;Persist Security Info=True;User ID=sa;Password=123";
            sqlConn.Open();

            SqlCommand sqlComm = new SqlCommand();
            sqlComm.Connection = sqlConn;
            sqlComm.CommandText = "SELECT * FROM  BanJ";

            SqlDataReader dataReader = sqlComm.ExecuteReader();
            while (dataReader.Read())
            {
                TreeNode newTreeNode = new TreeNode();
                newTreeNode.Text = dataReader["BanJ"].ToString();
                newTreeNode.Tag = dataReader["BianH"].ToString();

                this.treeView1.Nodes[0].Nodes.Add(newTreeNode);
                //this.treeView1.Nodes.Add(newTreeNode);
            }

            dataReader.Close();
            sqlConn.Close();

            this.treeView1.ExpandAll();//展开所有节点

        }