c#treeview的使用

来源：互联网发布：jsp连接sql的方法编辑：程序博客网时间：2024/04/30 07:22

       private void Bind()
        {

    SqlConnection conn = new SqlConnection();
    conn = DataAccess.DataAccessSqlconnection();
       DataSet ds = new DataSet();
       DataSet ds1 = new DataSet();
            ds=DataAccess.ReturnDataSet(conn,CommandType.Text,"select distinct(e_dept) from ep01","ep01");
            MessageBox.Show(ds.Tables[0].Rows.Count.ToString());
            TreeNode catenode;
            TreeNode pronode;
            foreach (DataRow caterow in ds.Tables[0].Rows)
            {
                catenode = new TreeNode();
                catenode.Text = caterow["e_dept"].ToString();
                catenode.Tag = caterow["e_dept"].ToString();
                treeView1.Nodes.Add(catenode);

                ds1 = DataAccess.ReturnDataSet(conn, CommandType.Text, "select e_no,e_name from ep01 where e_dept='" + caterow["e_dept"].ToString() + "'", "ep01");
                if (ds1.Tables[0].Rows.Count > 0)
                {
                    foreach (DataRow prorow in ds1.Tables[0].Rows)
                    {
                        pronode = new TreeNode();
                        pronode.Text = prorow["e_name"].ToString();
                        pronode.Tag = prorow["e_no"].ToString();
                        catenode.Nodes.Add(pronode);
                        //catenode.ChildNodes.Add(pronode);
                    }
                    //ds.Tables[0].Clear();
                }
            }

}