使用递归填充TreeView节点的方法

1.如:表TreeMenu 
NodeId,ParentId,Text,Url 
protected void Page_Load(object sender, EventArgs e) 
        { 
            BindCategoryTreeVew(CategoryView, true, "0"); 
        } 
        public DataSet GetCategorys() 
        { 
            string ConnectionString = ConfigurationManager.AppSettings["ConnectionString"]; 
            string sql = "select * from TreeMenu "; 
            SqlDataAdapter sda = new SqlDataAdapter(sql, ConnectionString); 
            DataSet ds = new DataSet(); 
            sda.Fill(ds); 
            return ds; 
        } 
        public void BindCategoryTreeVew(TreeView treeView, bool isExpanded, string sSelectedData) 
        { 
            //将获取的数据转换为 一个DataTable 
            DataTable dt = GetCategorys().Tables[0]; 
            treeView.Nodes.Clear();//清空 树的所有节点 
            //获取与排序顺序中的筛选器以及指定的状态相匹配的所有System.Data.DataRow 数组 
            DataRow[] rowlist = dt.Select("ParentId='0'"); 
            if (rowlist.Length <= 0) return; 
            //创建跟节点 
            TreeNode rootNode = new TreeNode(); 
            //设置根节点的属性 
            rootNode.Text = rowlist[0]["Text"].ToString(); 
            //设置根节点的值 
            rootNode.Value = rowlist[0]["NodeId"].ToString(); 
            rootNode.Expanded = isExpanded;