How to dynamically create navigation bar based on the role of user in ASP.NET webforms

See more:

ASP.NET

SQL

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