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/de...classtopic.asp.
You create hierarchy by assigning array of menuitems to menuItem.MenuItems
property.

HTH
Alex

"Yigit Ozgul" <yi********@yahoo.co.uk> wrote in message
news:3f**************************@posting.google.c om...

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