Treeview绑定数据库
需积分: 15 91 浏览量
2013-12-16
13:35:06
上传
评论 1
收藏 14KB DOCX 举报
public bool BuildTree(TreeView tv, DataSet ds)
{
tv.Nodes.Clear();
TreeNode n = new TreeNode();
n.Text = "全部员工";
this.TreeView1.Nodes.Add(n);
foreach (DataRow dbRow in ds.Tables[0].Rows)
{
if (dbRow["Up_id"].ToString() == string.Empty)
{
dbRow["Up_id"] = DBNull.Value;
}
}
ds.Relations.Add("NodeRelation", ds.Tables[0].Columns["ID"],
ds.Tables[0].Columns["Up_id"], false);
foreach (DataRow dbRow in ds.Tables[0].Rows)
{
if (dbRow.IsNull("Up_id"))
{
TreeNode newNode = CreateNode(dbRow["depart"].ToString(),
dbRow["ID"].ToString());
tv.Nodes.Add(newNode);
PopulateSubTree(dbRow, newNode);
}
}
//tv.ExpandAll();
return true;
}
private void PopulateSubTree(DataRow dbRow, TreeNode node)
{
foreach (DataRow childRow in dbRow.GetChildRows("NodeRelation"))
{
TreeNode childNode = CreateNode(childRow["depart"].ToString(),
childRow["ID"].ToString());
node.Nodes.Add(childNode);
PopulateSubTree(childRow, childNode);
}
}
private TreeNode CreateNode(string text, string tag)
{
TreeNode node = new TreeNode();
node.Text = text;
node.Tag = tag;
资源评论
