469,133 Members | 1,404 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,133 developers. It's quick & easy.

Creating a nested menu from DB

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
Jul 21 '05 #1
1 1617
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

Jul 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by John Topley | last post: by
6 posts views Thread by Sally Thompson | last post: by
14 posts views Thread by theo | last post: by
reply views Thread by Prakash C via .NET 247 | last post: by
2 posts views Thread by Prakash C via .NET 247 | last post: by
8 posts views Thread by Simon Edwards | last post: by
1 post views Thread by Yigit Ozgul | last post: by
1 post views Thread by Henrik Bechmann | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.