I would like to incorporate a DHTML hierarchical menu into the N-tier design of ThePhile. I need the menu to be populated with data from SQL Server 2000, creating an XML file from the database with each new user and cached on the client. If anybody has attempted this, a similar project, or knows where an example with code (preferably VB) can be found, I would appreciate any input.

There is cross browser dhtml menu solution at Sothink. It can generate menus from database.
http://www.sothink.com/campaigns/forumdmenu.php3

http://www.sothink.com/

Sothink DHTMLMenu 5.0 has released with a new interface and new features.


http://www.sothink.com/

Make sure you put the XML doc in the ASP.NET data cache, or else make it a user control and use the output cache.

You don't want to read directly from an XML file every time you generate a new page for a particular user.

Eric