Creating a nested menu from DB

[Yigit Ozgul]

Hi,

I have a database where i keep 4 tables.
the modules table:
mdlID
mdlName
mdlstatus


the submodules table:
subID
subname
mdlID
subparentID (I put this because there can be more nests)
subStatus


the events Table:
eventID
eventNAme
subID
eventStatus

the menu table:
menuID
eventID
userID

modules.mdlID=submodule.mdlID
subModule.subID=events.eventID
menu.eventID=events.eventID


every user has many rights. that is why I chose to relate users in the
event level. I am using C# and trying to build up a nested menu
structure for a specific user, using datasets etc.

I am giving an example of a menu

DEFINITIONS
-->CUSTOMER DEFINITIONS
-->COMPANY DEF
---->COMP representative DEF


Thanks for your help

Yigit Ozgul

 

[AlexS]

Hi, Yigit

take a look at
http://msdn.microsoft.com/library/d...rfsystemwindowsformscontextmenuclasstopic.asp.
You create hierarchy by assigning array of menuitems to menuItem.MenuItems
property.

HTH
Alex