ASP.NET TreeView讀取數(shù)據(jù)庫實例

2024-07-10 12:44:20

字體：大中小

供稿：網(wǎng)友

前臺：
代碼如下:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="TreeView._Default" %>

<!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.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace TreeView
{
    public partial class _Default : System.Web.UI.Page
    {
        public static string st = ConfigurationManager.ConnectionStrings["sql"].ToString();
        private DataTable dts=new DataTable();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                dts = CreateTable();
                CreateNode();
            }
        }
        public void CreateNode()
        {
            DataRow[] dr = dts.Select("ParentID=0");
            if(dr.Length>0)
            {
                foreach(DataRow drr in dr)
                {
                    TreeNode tn = new TreeNode();
                    tn.Value = drr["MenuID"].ToString();
                    tn.Text = drr["MenuName"].ToString();