default.aspx.cs

简单无限级分类（表格、下拉列表）源码 asp.net 2.0+access vs2008 制作。 简单的无限级栏目分类。包括下拉列表的分类显示和表格形式的分类显示。 适合新手。功能简单

///作者:魏宝辉
///网址:http://www.weibaohui.com
///版权所有，转载请注明
using System;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using FTchina;


public partial class _Default : System.Web.UI.Page
{

    
     protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            LoadList();
        }
    }

    /// <summary>
    /// 加载整个分类表
    /// </summary>
    private void LoadList()
    {
        litlist.Text = "";

        int MTcount = 0;//执行遍历的次数
        //开始迭代加载
        MakeTr("1", MTcount);

    }
    /// <summary>
    /// 装配每一行
    /// </summary>
    /// <param name="id">上级ID</param>
    /// <param name="count">迭代次数</param>
    private void MakeTr(string id, int count)
    {

        DataView dv = new DataView(shujuku.GetDataTable("select * from lanmu where parentid=" + id + " order by id asc"));
        foreach (DataRowView drv in dv)
        {
            //形成表格
            litlist.Text += "<tr><td>" + MakeFelgefu(count) + drv["context"].ToString() + "</td><td>自身编号" + drv["id"].ToString() + ",上级编号" + id + "</td></tr>";

            //形成下拉列表
            ListItem li = new ListItem(MakeFelgefu(count) + drv["context"].ToString(), drv["id"].ToString());
            ddllm.Items.Add(li);

            //再次遍历
            MakeTr(drv["id"].ToString(), count + 1);

        }

    }
    /// <summary>
    /// Make分隔符
    /// </summary>
    /// <param name="count"></param>
    /// <returns></returns>
    private string MakeFelgefu(int count)
    {
        string Returnwords = string.Empty;
        if (count == 0)
        {
            Returnwords = "";
        }

        else
        {
            Returnwords = ("├").PadLeft(count, '　');
        }
        return Returnwords;
    }

    



    protected void btnziok_Click(object sender, EventArgs e)
    {
        string parentid = ddllm.SelectedValue.ToString();
        string context = txbzifl.Text;
        string sql = "insert into lanmu (parentid,context) values(" + parentid + ",'" + context + "') ";
        shujuku.ExecuteSql(sql);
        LoadList();//更新列表

    }
    protected void btnroot_Click(object sender, EventArgs e)
    {
        string context =txbroot.Text;
        string sql = "insert into lanmu (parentid,context) values(1,'" + context + "') ";
       shujuku.ExecuteSql(sql);
       LoadList();//更新列表

    }
}