my22xo的专栏

C#学习中

用户操作

[留言] [发消息] [加为好友]

订阅我的博客

[编辑]my22xo的公告

欢迎光临我的博客，也欢迎访问我的asp.net做的小站http://iaocstock.vicp.net，呵呵，希望结识一些朋友共同学习C#

[编辑]文章分类

[编辑]我的网站

存档

asp.net2.0实现TreeView无限级分类（递归法）收藏

数据表

CREATE TABLE [dbo].[NewsClass](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Pid] [int] NULL DEFAULT ((0)),
[ClassName] [varchar](20) NOT NULL,
[OrderBy] [int] NULL DEFAULT ((0)),
PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

      private DataTable dt = new DataTable();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                BLL.NewsClass newsClass=new BLL.NewsClass();
                dt = newsClass.GetData("select * from NewsClass Order By OrderBy desc", null).Tables[0];//逻辑层自定义的代码 
                AddMyNode(null);
            }
        }
//递归算法： 
        /// <summary> 
        /// 递归实现无限级TreeView(Jason_iaoc) 
        /// </summary> 
        /// <param name="currentNode"></param> 
        private void AddMyNode(TreeNode currentNode)
        {
            if (currentNode == null)//添加根结点 
            {
                DataView dv = dt.DefaultView;
                dv.RowFilter = "pid=0";
                dv.Sort = "orderby desc";
                TreeNode node = null;
                foreach (DataRowView drv in dv)
                {
                    node = new TreeNode();
                    node.Value = drv["id"].ToString();
                    node.Text = drv["ClassName"].ToString();
                    node.Expanded = false;
                    this.TreeView1.Nodes.Add(node);
                    AddMyNode(node);
                }
            }
            else//添加子结点 
            {
                DataView dv = dt.DefaultView;
                dv.RowFilter = "pid=" + currentNode.Value;
                dv.Sort = "orderby desc";
                TreeNode node = null;
                foreach (DataRowView drv in dv)
                {
                    node = new TreeNode();
                    node.Value = drv["id"].ToString();
                    node.Text = drv["ClassName"].ToString();
                    node.Expanded = false;
                    currentNode.ChildNodes.Add(node);
                    AddMyNode(node);
                    //this.TreeView1.Nodes.Add(node); 
                }
            }
        }