Dear All,

I was using a  static web .sitemap to  populate a menu and a treeview.There are 5 levels, 3 of which are displayed in the menu and rest 2 in the treeview.

Then I decided to have a dynamically generated menu from a dynamically generated web.sitemap file which gets populated from the database.

Therefore I generate a XML file with data from the database and then change the format to that of Web.sitemap and finally save the XML file as Web.sitemap.

Then I call this function( which generates the web.sitemap) in the Load event of my master page so that the menu can populate at the beginning itself.

But the problem is that the menu doesn't populate, and neither does the treeview.

The application is able to find the Web.sitemap(otherwise it would throw error) but not reading its content.

So where is the problem?

I thought may be SiteMapDataSource's which I added by dragging & dropping from toolbox was not able to access the data in Web.sitemap.

Do I need to add them dynamically? IF so how do I attach them to the web.sitemap?

Your help wll be highly appreciated.

Thanks.

Hi,

You need not to generate Web.sitemap file programmaticall.

If you want to populated from the database, you can try to use the Custom Site Map Providers.

You can refer this msdn article: http://msdn2.microsoft.com/en-us/library/aa479320.aspx

about the SQL Server? site map provider, you can refer this article: http://msdn2.microsoft.com/en-us/magazine/cc163657.aspx

Hope it helps.

Hi Amanda,

The second link regarding Wicked Code article is useful for me but I knew it before only.

I followed the same article and able to generate the data for my menu and treeview but not able to get SQlCacheDependency to work.

If I write the statements given in the article it throwing errrors. I am using SQL SERVER 2005 express i.e one within the App_code.

Do u know how to do it?

Also pls do not mark your post as answer just after giving some links because u are not sure whether  the code in the links will work or not.U need to wait for my reply to find out as to whether your post has been really helpful.

Thanks.