I have googled search for a while but still couldn't get the right articles or examples to put me through. I'm currently working(learning) on a role based application which i doing well. I'm currently having a problem. i have a table in my sql db called SiteMap. This table has the following columns (id, Title, Description, Url, roles, parentId, TabType and TabOrder). I have values for each columns. What i want to achieve is that when a user logs in, i want to have navbar based on the role of that user. If the user is a guest, I want to display a navbar with the roles of just guest. How do i have this?
What I have tried:
here is how the db looks like
id Title Description Url roles parentId TabType TabOrder
1 ROOT ROOT * NULL 0 0
2 Administrator Padmin PortalAdmin# Admin 1 1 2
3 Report Reporting# Admin 1 1 3
4 Ticket Ticket Admin;Guest 1 1 4
5 Manage Ticket Mticket.aspx Guest 4 4 2
here is a summary of what i want to do. When a user that is with the role of guest logs in, only Ticket(with sub menu Manage Ticket) should be in the navbar. If its a user with Admin role, Portal Administration, Report, Ticket(with submenu Manage Ticket) should be displayed in the navbar. I hope you do understand what i explained. Thanks