treeView添加一级二级三级节点。

 this.treeView1.Nodes.Clear();
            //取出第一级
            string sql = "select qxid,ssfz,fzmc from lab_zhqx where fzjb=" + 1 + "";
            SqlDataAdapter sda = new SqlDataAdapter(sql, alluse.Class1.conn1);
            DataSet ds = new DataSet();
            sda.Fill(ds, "lab_zhqx");
            //
            string sql1 = "select qxid,ssfz,fzmc from lab_zhqx where fzjb=" + 2 + "";
            SqlDataAdapter sda1 = new SqlDataAdapter(sql1, alluse.Class1.conn1);
            DataSet ds1 = new DataSet();
            sda1.Fill(ds1, "lab_zhqx");
            //
            string sql2 = "select ssfz,zhmc from lab_zhgl";
            SqlDataAdapter sda2 = new SqlDataAdapter(sql2, alluse.Class1.conn1);
            DataSet ds2 = new DataSet();
            sda2.Fill(ds2, "lab_zhgl");