I have an ASP.NET website (web forms) that pulls navigation menu items from a database table. Currently it is one menu list that populates 2 levels (menu item and some of those items have sub menu items.)
Currently I'm using a literal/DataList to display the <li> for each link. On the binding of the list, I'm searching the table for submenu items and essentially doing the same thing. This is all done on a master page.
As you can imagine, this causes for a lot of trips back/forth to the DB. I know there are a lot better way of doing this but I'm not really sure where to start. Populating this dropdown menu must be done from some sort of source. What is the best way to do this. I'm not really looking for a 3rd party control, though I suppose I'd entertain it if I could just drop it into my literal or some other simple method.