根据数据库表生成树。

private void Form1_Load(object sender, EventArgs e)
        {
           SqlConnection loadtree = new SqlConnection(@"Data Source=(local);Initial Catalog=usertest;uid=sa;pwd=123");
            loadtree.Open();
             //SqlCommand num = new SqlCommand("select count(*)  from 井信息 group by 区块", loadtree);
            //SqlDataReader sdr = num.ExecuteReader();
            SqlDataAdapter da = new SqlDataAdapter("select 区块,count(*) as cc from 井信息 group by 区块", loadtree);
            DataSet ds = new DataSet();
            da.Fill(ds,"0");
            int num1,i ,j= 0;
             num1=(Int32)ds.Tables[0].Rows.Count;
         dataGridView1.DataSource = ds.Tables[0];
            for (j = 0; j <ds.Tables[0].Rows.Count; j++)
            {   
                SqlDataAdapter da2 = new SqlDataAdapter("select distinct 井队号 from 井信息 where 区块='"