TreeView控件动态绑定数据库内容

数据库结构：

表1：FID，DataName两个用到的字段，注意其中DataName为FID的名字

表2：FID，SID，DataName三个用到的字段，注意其中DataName为SID的名字

表1与表2关联字段为FID

后台CS文件封装函数代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient; //引入命名空间
using System.Configuration; //引入命名空间
using System.Web.UI.WebControls; //引入命名空间

/// <summary>
///BindTree 的摘要说明
/// </summary>
public class BindTree
{
 public BindTree()
 {
  //
  //TODO: 在此处添加构造函数逻辑
  //
 }
    #region
    /// <summary>
    /// 绑定Treeview,添加父节点
    /// </summary>
    /// <param name="sqlstr">sql查询字符串</param>
    /// <param name="tv">treeview控件的名称</param>
    /// <param name="idDataName">从节点id数据库字段名</param>
    /// <param name="TextDataName">从节点名称数据库字段名</param>
    public void AddParentNode(string sqlstr,TreeView tv,string idDataName,string TextDataName)
    {
        SqlConnection cn = conn.CreateConnection();
        cn.Open();
        SqlCommand cm = new SqlCommand(sqlstr,cn);
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = cm;
        DataTable dt = new DataTable("table1");
        sda.Fill(dt);
        DataView dv = new DataView(dt);//将DataTable存到DataView中，以便于筛选数据
        cn.Close();
        cn.Dispose();
        TreeNode tn;
        foreach (DataRowView   r in dv)
        {
            tn = new TreeNode();
            tn.Value = r[idDataName].ToString();
            tn.Text = r[TextDataName].ToString();
            tv.Nodes.Add(tn);
            AddChildNode("select * from [DataSecond]",tv,tn,tn.Value,"FID","SID","DataName");
            tn.Expanded = true;
        }
    }
    #endregion
    #region
    /// <summary>
    /// 绑定Treeview
    /// </summary>
    /// <param name="tv">treeview控件的名称</param>
    /// <param name="pnode">treeview的一个父节点</param>
    /// <param name="pid">父节点的id值</param>
    /// <param name="pidDataName">父节点id的数据库字段名</param>
    /// <param name="idDataName">从节点id数据库字段名</param>
    /// <param name="TextDataName">从节点名称数据库字段名</param>
    public void AddChildNode(string sqlstr, TreeView tv,TreeNode parentnode,string parentid,string parentIdDataName, string idDataName, string TextDataName)
    {
        SqlConnection cn = conn.CreateConnection();
        cn.Open();
        SqlCommand cm = new SqlCommand(sqlstr, cn);
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = cm;
        DataTable dt = new DataTable("table1");
        sda.Fill(dt);
        DataView dv = new DataView(dt);//将DataTable存到DataView中，以便于筛选数据
        TreeNode tn;
        string filter = string.Format(parentIdDataName + "='{0}'", parentid);
        dv.RowFilter = filter;//利用DataView将数据进行筛选
        cn.Close();
        cn.Dispose();
        foreach (DataRowView r in dv)
        {
            tn = new TreeNode();
            tn.Value = r[idDataName].ToString();
            tn.Text = r[TextDataName].ToString();
            tn.NavigateUrl = "ShowData.aspx?SID=" + r[idDataName].ToString();
            tn.Target = "center";
            parentnode.ChildNodes.Add(tn);
        }
    }
    #endregion
}

网页中引用代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class WebPages_DataAll : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindTree bt = new BindTree();
            bt.AddParentNode("select * from [DataFirst]",TreeView1,"FID","DataName"); //调用方法
        }
    }
}