treeview绑定数据（winform）

Question

treeview 在页面初始化的时候绑定数据 具体要求是 部门是根目录，下面有管理部门，财务部门，生产部门各个部门下有员工
请问如何绑定？？？

Answer 1

用 SQL 語 句組合好直接執行出來

Answer 2

/// <summary>
/// 设置树结点的算法。
/// </summary>
/// <param name="view">自定义的视图，视图是GroupTable表的</param>
/// <param name="nodes">TreeNode对象集合</param>
private void SetTreeNode(DataView view,System.Windows.Forms.TreeNodeCollection nodes)
{
foreach(DataRowView rowView in view)
{
TreeNode node=nodes.Add(rowView["GroupName"].ToString());
node.ImageIndex=0;
node.Tag=rowView["ID"];
DataView v=new DataView(m_group,"[Parent]="+rowView["ID"].ToString(),"",DataViewRowState.CurrentRows);
//
DataView v_Post=new DataView(m_post,"[GroupID]="+rowView["ID"].ToString(),"",DataViewRowState.CurrentRows);
//
foreach(DataRowView rowView_Post in v_Post)
{
TreeNode nodePost=node.Nodes.Add(rowView_Post["Post"].ToString());
nodePost.ImageIndex=1;
nodePost.Tag=rowView_Post["ID"];
DataView v_Man=new DataView(m_man,"[PostID]="+rowView_Post["ID"].ToString(),"",DataViewRowState.CurrentRows);
foreach(DataRowView rowView_Man in v_Man)
{
TreeNode nodeMan=nodePost.Nodes.Add(rowView_Man["Name"].ToString());
nodeMan.Tag=rowView_Man["ID"];
nodeMan.ImageIndex=2;
}
}
//
if (0==v.Count)
{
continue;
}
else
SetTreeNode(v,node.Nodes);
}
}
/// <summary>
/// 遍历数据库，建立树型结构。
/// </summary>
/// <param name="Nodes">TreeNode对象集合</param>
public void GetSetTreeNode(System.Windows.Forms.TreeNodeCollection Nodes)
{
m_group=this.GetGroupTable();
m_man=this.GetManInnerManPostAndPost();
m_post=this.GetPostInnerGroup();
DataView view=new DataView(m_group,"[Parent]=0","",DataViewRowState.CurrentRows); 
if (0==view.Count)
return;
else
SetTreeNode(view,Nodes);
}

Answer 3

楼上的朋友，请加点注释说明好吗？我用的是 mysql数据库