C#创建树结构

定义建立子节点函数（递归）：

    class Class1
    {

        public void GetChildTree(string pid, TreeNode tns)
          {
              SqlConnection con = new SqlConnection("Persist Security Info=False;User id=sa;pwd=123;database=WDERPDATA_001;server=(local)");
              con.Open();
              string sql = "select * from TBASE_DEPT ORDER BY BM_DEPT_CODE";
              SqlDataAdapter sda = new SqlDataAdapter(sql, con);
              //提交查询 获取结果数据集
              DataSet ds = new DataSet();
              sda.Fill(ds, "TBASE_DEPT");
              //获取TBASE_DEPT表
              DataTable dt = ds.Tables["TBASE_DEPT"];
           

            //  string two = "len(BM_DEPT_CODE)=4 and SUBSTRING(BM_DEPT_CODE,1,2)=" + tdr1["BM_DEPT_CODE"];