TreeView

TreeView绑定数据：

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

public partial class Default3 : 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 sql = ConfigurationManager.ConnectionStrings["sqlstr"].ConnectionString;
using (SqlConnection sqlCnn = new SqlConnection(sql))
{
SqlCommand sqlCmm = sqlCnn.CreateCommand();
sqlCmm.CommandText = "select * from menutree order by parentid,menuorder";
SqlDataAdapter adapter = new SqlDataAdapter(sqlCmm);
DataSet ds = new DataSet();
adapter.Fill(ds);
return ds.Tables[0];
}
}
}

使用站点地图绑定数据：

<?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="dexi.aspx" title="德系"></siteMapNode>
<siteMapNode url="meixi.aspx" title="美系"></siteMapNode>
<siteMapNode url="rixi.aspx" title="日系"></siteMapNode>
</siteMapNode>
<siteMapNode url="hezi.aspx" title="合资车" description="" />
<siteMapNode url="guochan.aspx" title="国产车" description="" />
</siteMapNode>
</siteMap>