private void branchmaneger_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string s = "select branchnumname,WorkerName from branchnum inner join " +
"Worker on Worker.branchnumID=branchnum.branchnumID";
SqlDataAdapter sqlda = new SqlDataAdapter(s, da.link());
sqlda.Fill(ds, "branchnum");
SqlDataAdapter sqlda1 = new SqlDataAdapter("select branchnumname from branchnum", da.link());
sqlda1.Fill(ds, "branchnum");
TreeNode tn;
foreach (DataRow dr in ds.Tables[0].Rows)//"branchnum1"
{
tn = new TreeNode(dr[0].ToString());//先添加部门
treeView1.Nodes.Add(tn);
//branchlist.Nodes.Add(tn);
foreach (DataRow dr1 in ds.Tables[0].Rows)//"branchnum1"
{
if (dr1[0].ToString() == dr[0].ToString())
{
tn.Nodes.Add(dr1[1].ToString());
}
}
}
}
上面是向TreeView控件中添加节点的代码。但是运行结果中老重复出现节点。在循环当中哪给出错了?在表中有两个部门(铁丝和塑料)。运行结果是:
铁丝
塑料
铁丝
铁丝
塑料
塑料
塑料
铁丝
塑料
出现这么多重复的。怎么让他只出现铁丝和塑料呢?
{
DataSet ds = new DataSet();
string s = "select branchnumname,WorkerName from branchnum inner join " +
"Worker on Worker.branchnumID=branchnum.branchnumID";
SqlDataAdapter sqlda = new SqlDataAdapter(s, da.link());
sqlda.Fill(ds, "branchnum");
SqlDataAdapter sqlda1 = new SqlDataAdapter("select branchnumname from branchnum", da.link());
sqlda1.Fill(ds, "branchnum");
TreeNode tn;
foreach (DataRow dr in ds.Tables[0].Rows)//"branchnum1"
{
tn = new TreeNode(dr[0].ToString());//先添加部门
treeView1.Nodes.Add(tn);
//branchlist.Nodes.Add(tn);
foreach (DataRow dr1 in ds.Tables[0].Rows)//"branchnum1"
{
if (dr1[0].ToString() == dr[0].ToString())
{
tn.Nodes.Add(dr1[1].ToString());
}
}
}
}
上面是向TreeView控件中添加节点的代码。但是运行结果中老重复出现节点。在循环当中哪给出错了?在表中有两个部门(铁丝和塑料)。运行结果是:
铁丝
塑料
铁丝
铁丝
塑料
塑料
塑料
铁丝
塑料
出现这么多重复的。怎么让他只出现铁丝和塑料呢?
{
tn = new TreeNode(dr[0].ToString());//先添加部门
treeView1.Nodes.Add(tn);
//branchlist.Nodes.Add(tn);
}
这就可以了吧 你打数据发上来看结构是什么样的