TreeView控件的使用

 

TreeView绑定数据
1、在TreeView的属性Nodes中添加
2、在Web.sitemap页面中添加
    <?xml version="1.0" encoding="utf-8" ?>
<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
    <siteMapNode url="default.aspx" title="首页"  description="">
  <siteMapNode url="jinkou.aspx" title="进口"  description="">
   <siteMapNode url="meixi.aspx" title="美系" description=""/>
   <siteMapNode url="rixi.aspx" title="日系" description=""/>
   <siteMapNode url="dexi.aspx" title="德系" description=""/>
  </siteMapNode>
        <siteMapNode url="hezi.aspx" title="合资车"  description="" />
  <siteMapNode url="guochan.aspx" title="国产车"  description="" />
    </siteMapNode>
</siteMap>
3.在后台代码中添加
  protected void Page_Load(object sender, EventArgs e)
    {
        TreeNode root = new TreeNode("首页", "shouye");
        root.NavigateUrl = "default2.aspx";

        TreeNode nodejinkou = new TreeNode("进口", "jinkou");
        nodejinkou.NavigateUrl = "jinkou.aspx";
        root.ChildNodes.Add(nodejinkou);

        TreeNode nodehezi = new TreeNode("合资", "hezi");
        root.ChildNodes.Add(nodehezi);

        TreeNode nodemeixi = new TreeNode("美系", "meixi");
        nodejinkou.ChildNodes.Add(nodemeixi);

        this.TreeView1.Nodes.Add(root);

        if (!IsPostBack)
            bindTree();
    }
4.从数据库中获取数据
  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["treecnn"].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];
        }
    }