静态绑定TreeView(两层foreach循环)

    /// <summary>
    /// 页面加载
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindTreeView();
        }
    }

    /// <summary>
    /// 绑定信息
    /// </summary>
    private void BindTreeView()
    {
        this.TreeView1.Dispose();//清空节点
        this.TreeView1.ExpandDepth = 0;//TreeView控件展开的层次数
        DataView dv = new DataView();
        dv.Table = GetFindAll().Tables["SysFun"];//取出要显示的表
        dv.RowFilter = "ParentNodeId=0";//要查看的行的表达式

        foreach (DataRowView item in dv)//根节点
        {
            TreeNode tn = new TreeNode();
            tn.Value = item["NodeId"].ToString();
            tn.Text = item["DisplayName"].ToString();
            //tn.NavigateUrl = item["NodeURL"].ToString();
            this.TreeView1.Nodes.Add(tn);//将根节点添加到TreeView控件中

            DataView dvs = new DataView();
            dvs.Table = GetFindAll().Tables["SysFun"];
            dvs.RowFilter = "ParentNodeId=" + tn.Value;
            foreach (DataRowView items in dvs)//子节点
            {
                TreeNode tns = new TreeNode();
                tns.Value = items["NodeId"].ToString();
                tns.Text = items["DisplayName"].ToString();
                tns.NavigateUrl = items["NodeURL"].ToString();//绑定要跳转的地址
                tn.ChildNodes.Add(tns);//将子节点添加到根节点中
            }
        }
    }

    /// <summary>
    /// 获取数据信息
    /// </summary>
    /// <returns></returns>
    public DataSet GetFindAll()
    {
        SqlConnection conn = new SqlConnection("Data Source=172.16.122.76;Initial Catalog=MyOffice;Persist Security Info=True;User ID=sa;Password=sa");
        SqlDataAdapter da = new SqlDataAdapter("select * from SysFun",conn);
        DataSet ds = new DataSet();
        da.Fill(ds,"SysFun");
        return ds;
    }