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 区块='" + ds.Tables[0].Rows[j][0].ToString() + "'", loadtree);
string c = j.ToString()+1;
da2.Fill(ds,c);
treeView1.Nodes.Add(new TreeNode(ds.Tables[0].Rows[j][0].ToString()));
for (i = 0; i < (Int32)ds.Tables[0].Rows[j][1]; i++)
{
treeView1.Nodes[j].Nodes.Add(ds.Tables[c].Rows[i][0].ToString());
}
}
链接数据库,并按照两列对应的数据生成树。
根据数据库表生成树。
最新推荐文章于 2024-06-09 12:05:38 发布