如何从数据库生成水平子菜单? [英] How to generate Horizontal submenu from database?

问题描述

我想从数据库生成动态菜单；我可以生成一个子菜单；但我想在子菜单下生成这样的子菜单

菜单>>
子菜单1>>
SubMenu2>> SubMenu2a
............. SubMenu2b

我已经尝试过以下代码..以生成一个子菜单..

i want to generate dynamic menu from database; i can generate one submenu; but i want to generate submenu under submenu like this

Menu>>
SubMenu1>>
SubMenu2>>SubMenu2a
.............SubMenu2b

I have tried this following code..to generate one submenu..

DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        string sql = "Select * from Menu";
        SqlDataAdapter da = new SqlDataAdapter(sql, con);
        da.Fill(ds);
        dt = ds.Tables[0];
        DataRow[] drowpar = dt.Select("ParentID=" + 0);

        foreach (DataRow dr in drowpar)
        {
            menuBar.Items.Add(new MenuItem(dr["MenuName"].ToString(), dr["MenuID"].ToString(), "", dr["MenuLocation"].ToString()));
        }

        foreach (DataRow dr in dt.Select("ParentID >" + 0))
        {
            MenuItem mnu = new MenuItem(dr["MenuName"].ToString(), dr["MenuID"].ToString(), "", dr["MenuLocation"].ToString());
            
                menuBar.FindItem(dr["ParentID"].ToString()).ChildItems.Add(mnu);
            
        }

数据库结构是这样的:
MenuID MenuName MenuLocation ParentID
1菜单AA 0
2 SubMenu1 AB 1
3子菜单2 AC 1
4 SubMenu2a AD 3
5 SubMenu2b AE 3

有人可以指导我如何在子菜单下生成子菜单吗?

Database structure is like this:
MenuID MenuName MenuLocation ParentID
1 Menu AA 0
2 SubMenu1 AB 1
3 SubMenu2 AC 1
4 SubMenu2a AD 3
5 SubMenu2b AE 3

Can anyone guide me how to generate submenu under a submenu?

推荐答案

Dynamic MainMenu formation in WinForm Application using DataSet
I think it works, But it''s better in the database for root menu set ParentID = ID (Not null)

您好，

请仔细阅读CP中的以下文章，看看它是否对您有帮助:
从ASP.NET中的数据库中动态填充菜单项 [ ^ ]
其他一些指针:
http://www.dotnetfunda.com/articles/article1474-creating-dynamic- menu-in-aspnet.aspx [ ^ ]

关于同一件事的高级文章:
http://www.c-sharpcorner .com/UploadFile/4e2862/dynamic-creating-menus-and-submenus-items-to-web-forms/ [

Hello,

Please go through below article in CP, see if it helps you:
Dynamically populating menu items from the database in ASP.NET[^]
Some other pointer:
http://www.dotnetfunda.com/articles/article1474-creating-dynamic-menu-in-aspnet.aspx[^]

An advanced article on the same thing:
http://www.c-sharpcorner.com/UploadFile/4e2862/dynamically-creating-menus-and-submenus-items-to-web-forms/[^]

感谢

Thanks to

Quote :

Prabhat Kr.辛格(Singh)

Prabhat Kr. Singh

[ ^ ]

这篇关于如何从数据库生成水平子菜单?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！