递归绑定TreeView
树形菜单在平常的开发中是最常见的了,自已也练习练习,先来看两个图:
效果图 表结构
实现代码:
private void Form1_Load(object sender, EventArgs e)
{
this.BindTree(0);
}
private DataSet GetData(int pid)
{
string strCon = @"Data Source=Agony\SQLSERVER2005;Initial Catalog=sports;Integrated Security=True";
string sql = "SELECT * FROM sport WHERE pid=" + pid;
SqlConnection conn = new SqlConnection(strCon);
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds, "sport");
return ds;
}
//绑定父节点
private void BindTree(int pid)
{
DataSet ds = GetData(pid);
if (ds.Tables["sport"].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables["sport"].Rows.Count; i++)
{
TreeNode node = new TreeNode();
node.Text = ds.Tables["sport"].Rows[i]["sname"].ToString();
node.Tag = ds.Tables["sport"].Rows[i]["id"].ToString();
this.treeView1.Nodes.Add(node);
BindChildNode(node);
}
}
}
//绑定子节点
private void BindChildNode(TreeNode node)
{
TreeNode tn = node;
int id = Convert.ToInt32(tn.Tag);
DataSet ds = GetData(id);
for (int i = 0; i < ds.Tables["sport"].Rows.Count; i++)
{
TreeNode nod = new TreeNode();
nod.Text = ds.Tables["sport"].Rows[i]["sname"].ToString();
nod.Tag = ds.Tables["sport"].Rows[i]["id"].ToString();
tn.Nodes.Add(nod);
BindChildNode(nod);
}
}
作者:Glen.He
出处:http://www.cnblogs.com/puresoul/
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。