从数据库读取节点，动态绑定TreeView

最新推荐文章于 2023-08-04 16:47:19 发布

flash_angle

最新推荐文章于 2023-08-04 16:47:19 发布

阅读量1.3k

点赞数

文章标签：数据库 dataset menu server xhtml string

本文链接：https://blog.csdn.net/flash_angle/article/details/3490318

版权

从数据库读取节点，动态绑定TreeView

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TreeView.aspx.cs" Inherits="Admin_Page_TreeView" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title></title>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form id="form1" runat="server">
<div>
<asp:TreeView ID="tv" runat="server" ImageSet="Arrows" ShowLines="True" ExpandDepth="1">
<ParentNodeStyle Font-Bold="False" />
<HoverNodeStyle Font-Underline="True" ForeColor="#5555DD" BorderStyle="None" />
<SelectedNodeStyle
Font-Underline="False" HorizontalPadding="0px" VerticalPadding="0px" ForeColor="#5555DD" />
<NodeStyle Font-Names="Verdana" Font-Size="14px" ForeColor="Black" HorizontalPadding="5px"
NodeSpacing="0px" VerticalPadding="0px" />
</asp:TreeView>
</div>
</form>
</body>
</html>

TreeView.Aspx.CS部分

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class Admin_Page_Menu_List : WebFormCommon
{
private DataSet dstv = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();//获取数据源
bindtree(tv.Nodes,"0");//帮定树
}
}
private void bindtree(TreeNodeCollection Nds, string strFartherID)
{
DataRow[] rows = dstv.Tables[0].Select("menu_fatherID=" + strFartherID);
TreeNode tmpNd;
foreach (DataRow row in rows)
{
tmpNd = new TreeNode();
tmpNd.Value = row["menu_id"].ToString();
tmpNd.Text = row["menu_name"].ToString();
tmpNd.NavigateUrl = "Menu_AddOrMod.aspx?id=" + tmpNd.Value;
tmpNd.Target = "right";
Nds.Add(tmpNd);
bindtree(tmpNd.ChildNodes, tmpNd.Value);//递归调用方法
}
}
private void BindGrid()
{
DataSet ds = new DataSet();
string sql = "select * from web_menu order by menu_fatherid,menu_id asc";
ds = SqlHelper.BindSql_ReturnDataSet(sql);//读取数据返回DataSet
dstv = ds;
}

}