C#動(dòng)態(tài)綁定treeview控件

    前臺(tái)只需要放一個(gè) treeview控件就行
    后臺(tái)
    protected void Page_Load(object sender, EventArgs e)
    {
    if (!IsPostBack)
    bindTree();
    }
    private void bindTree()
    {
    DataTable dt = this.GetTreeData();
    this.FillNode(dt, null);
    }
    private void FillNode(DataTable dt, TreeNode node)
    {
    DataView dv = new DataView(dt);
    if (node == null) //根結(jié)點(diǎn)
    {
    dv.RowFilter = "parentid='0'"; //篩選到根結(jié)點(diǎn)的所有子節(jié)點(diǎn)
    }
    else //不是根結(jié)點(diǎn)
    {
    dv.RowFilter = "parentid='" + node.Value + "'"; //篩選對(duì)應(yīng)節(jié)點(diǎn)的所有子節(jié)點(diǎn)
    }
    foreach (DataRowView drv in dv) //遍歷填充節(jié)點(diǎn)的所有子節(jié)點(diǎn)，如果傳入的節(jié)點(diǎn)node為葉子節(jié)點(diǎn)，遍歷要退出，不再進(jìn)行遞歸
    {
    TreeNode no = new TreeNode(drv["menuname"].ToString(), drv["menuid"].ToString());
    FillNode(dt, no); //填充no節(jié)點(diǎn)的子節(jié)點(diǎn)
    if (node == null)
    {
    this.TreeView1.Nodes.Add(no);
    }
    else
    {
    node.ChildNodes.Add(no);
    }
    }
    }
    private DataTable GetTreeData()
    {
    string strcnn = ConfigurationManager.ConnectionStrings["treecnn"].ConnectionString;
    using (SqlConnection sqlcnn = new SqlConnection(strcnn))
    {
    SqlCommand sqlcmm = sqlcnn.CreateCommand();
    sqlcmm.CommandText = "select * from MenuTree order by parentid,menuorder";
    SqlDataAdapter da = new SqlDataAdapter(sqlcmm);
    DataSet ds = new DataSet();
    da.Fill(ds);
    return ds.Tables[0];
    }
    }