2/26/2006 10:09:00 PM

i'm interested in how you implemented this. I'm pretty new with ASP.NET and have implemented the SQLSiteMap Provider (using MySQL 5.0) and works fine so far. Except same issue with database changes don't show up on the sitemap, unless I resave the files. When you put the "Public Interface IRefreshable" into the SQLSiteMap Provider, did you just add those lines or what did you have to change? Also in you CMS how are you calling the refresh method.
Thanks

Greg

2/28/2006 5:26:00 PM

What I did was in the code that save the changes to CMS, I use the above code to Refresh the siteMapProvider.

Li Chen

3/6/2006 10:32:00 AM

Do you know why the siteMap clears? I have that problem, that my menues suddenly dissapeare at PostBack. Thought that it might be the same problem as you had...

Pether

3/11/2006 3:37:00 PM

I had similar problem when I turned on SQL Server Notification. When I set a break points in the program, I found SQL Server Notification fired for no reason right after the SQLSiteMap provider read the site map in and clear the site map. I could not use it in a predictive way. That is why I went to this alternative way to refresh my sitemap.

Li Chen

3/22/2006 3:22:00 PM

I just added a Public Refesh method to the SQLSiteMapProvider Class. So I can refesh whenver i want.
addition to the class (C#):
public void Refresh()
{
Clear();
_nodes.Clear();
_root = null;
}

that how i refesh SiteMap in my code(VB.NET):
Dim SiteMapProv As SqlSiteMapProvider = SiteMap.Provider
SiteMapProv.Refresh()

ghozy