Newbie looking for help... Data driven navigation

Is it possible to generate ASP.net website navigation based entirely on SQL queries?

If so, is it better to generate a static sitemap by running these queries only when a change is made to the database,

or

is it better to allow the queries to run "realtime" on page load and whenever a link is clicked?

Sorry if I'm not too clear, I'm still "extremely" wet behind the ears. ;-)

Thanks in advance,

Jeff

Well not sure if this is the answer you are looking for, but Asp.net 2.0 has a very good new feature Site Map where you can use the Site Map Provider to configure your Navigation of your website.

Hi,

Take a look at these tutorials

http://quickstarts.asp.net/QuickStartv20/aspnet/doc/ctrlref/data/sitemapdatasource.aspx

http://www.asp.net/learn/data-access/tutorial-62-cs.aspx

One thing you might want to do is cache the SiteMap the first time your page load, that way you will avoid unnecessary db roundtrips.

However if your SiteMap is going to be changing all the time than you can leave the caching out.

Goodluck

The second link is exactly what I was looking for. Thanks.

The link you posted is appending an extra character though, breaking the link, so I reposted it below. (This link points to the VB tutorial)

http://www.asp.net/learn/data-access/tutorial-62-vb.aspx

Jeff