how retrieve catergory form database for menulist

praban

hi friends
im basic develop i have i problem ,

i'm creating the website for upload ads but. i put hard code to the menu.
i need the menu list should directly come from database.
i try some code but that are retrieve the data form database
"but it retrieve automatically link the other page. "

Strider64

I do something like this in php, I don't know if this is what you mean?

praban

thank you

Flack

If you're working in ASP.NET, you can put a menu control, and write the query as a stored procedure then stick a datasource on the page and hook them all up. For menus like this that are unlikely to change frequently but appear on all pages, you should also use caching, which can easily be turned on in the control in .net. If you're serving 10,000 pages per day, you don't want to be making 10,000 round trips to the db to get exactly the same data when you can do just one.