动态生成menu

最新推荐文章于 2024-05-21 17:13:50 发布

转载最新推荐文章于 2024-05-21 17:13:50 发布 · 66 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/luyongqun/archive/2007/04/25/726380.html

本文介绍了一个使用ASP.NET实现动态菜单加载的方法。通过从数据库中读取分类信息，并利用SqlDataAdapter填充数据集，实现了将分类显示为网站菜单的功能。此外，还详细展示了如何递归地加载子级分类。

string strSQL = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            strSQL = "Select * from tBigClass";
            DataView dvMain = dv(strSQL);
            foreach (DataRowView dvRV in dvMain)
            {
                MenuItem mi = new MenuItem();
                mi.Text = dvRV["MBTitle"].ToString();
                mi.Value = dvRV["id"].ToString();
                Menu1.Items.Add(mi);
                AddchildItem(mi);
            }
        }
    }

    private void AddchildItem(MenuItem mi)
    {
        int id = Convert.ToInt32(mi.Value);
        DataView dvChild = dv("select * from tSmallClass where MSPid=" + id);
        foreach (DataRowView dvRV in dvChild)
        {
            MenuItem min = new MenuItem();
            min.Text = dvRV["MSTitle"].ToString();

mi.ChildItems.Add(min);

}

    private DataView dv(string query)
    {
        string strConn;
        SqlConnection sqlConn;
        strConn = System.Configuration.ConfigurationManager.AppSettings["ConnectString"];
        sqlConn = new SqlConnection(strConn);
        sqlConn.Open();
        SqlDataAdapter sda = new SqlDataAdapter(query, sqlConn);
        DataSet ds = new DataSet();
        sda.Fill(ds, "tClass");
        return ds.Tables["tClass"].DefaultView;
    }

转载于:https://www.cnblogs.com/luyongqun/archive/2007/04/25/726380.html