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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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