C# winform Treenode 递归

我给你一个
DataTable dt = new DataTable();
//窗体加载的时候获得数据源
private void Form1_Load(objectsender, EventArgs e)
{
SqlConnection con = newSqlConnection("server=.;uid=sa;pwd=;database=pubs");
SqlDataAdapter da = new SqlDataAdapter("select * from menuinfo",con);
this.treeView1.Nodes.Clear();
da.Fill(this.dt);
//添加父节点
TreeNode node =new TreeNode();
node.Tag =dt.Rows[0][0].ToString();
node.Text =dt.Rows[0][1].ToString();
this.treeView1.Nodes.Add(node);
this.Bind(node); //自定义方法 见下
}
public void Bind(TreeNode node)
{
DataRow[]drs = this.dt.Select("m_parent_id=" + node.Tag);
foreach (DataRow dr in drs)
{
TreeNode n = new TreeNode();
n.Tag = dr[0].ToString();
n.Text = dr[1].ToString();
node.Nodes.Add(n);
this.Bind(n);
}
}