ASP.NET高级应用之　(站点导航SiteMapPath控件)

最新推荐文章于 2019-07-08 09:43:29 发布

心如止静

最新推荐文章于 2019-07-08 09:43:29 发布

阅读量501

点赞数

本文链接：https://blog.csdn.net/qhx556/article/details/8309196

版权

前台：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TreeDemo3.aspx.cs" Inherits="TreeViewDemo.TreeDemo3" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

后台：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace TreeViewDemo
{
public partial class TreeDemo3 : System.Web.UI.Page
{

        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)    //根结点
            {
                dv.RowFilter = "parentid='0'"; //筛选到根结点的所有子节点
            }
            else //不是根结点
            {
                dv.RowFilter = "parentid='" + node.Value + "'";   //筛选对应节点的所有子节点
            }
            foreach (DataRowView drv in dv)   //遍历填充节点的所有子节点，如果传入的节点node为叶子节点，遍历要退出，不再进行递归
            {
                TreeNode no = new TreeNode(drv["menuname"].ToString(), drv["menuid"].ToString());
                FillNode(dt, no); //填充no节点的子节点
                if (node == null)
                {
                    this.TreeView1.Nodes.Add(no);
                }
                else
                {
                    node.ChildNodes.Add(no);
                }
            }
        }
        private DataTable GetTreeData()
        {
            string strcnn = ConfigurationManager.ConnectionStrings["treeCon"].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];
            }
        }