treeView绑定数据库显示

 private void bindTreeView()
        {
            DataSet ds = new DataSet();
            ds = BLL_CompanyInfo.department();
            DataTable dt = new DataTable();
            dt = ds.Tables[0];
            tvDepartment.Nodes.Clear();
            CreateTreeViewRecursive(tvDepartment.Nodes, dt, 0);
        }
        private void CreateTreeViewRecursive(TreeNodeCollection nodes, DataTable dataSource, int DptParentId)
        {
            string filter;
            filter = string.Format("D_pid={0}", DptParentId);

            DataRow[] drarr = dataSource.Select(filter);//同一级的节点数据
            TreeNode node;
            foreach (DataRow dr in drarr)
            {
                node = new TreeNode();
                node.Text = dr["D_Name"].ToString();
                node.Value = dr["D_Id"].ToString();
                nodes.Add(node);
                CreateTreeViewRecursive(node.ChildNodes, dataSource, Convert.ToInt32(node.Value));
            }
        }