I've been playing around with URL rewriting lately, and found out a lot of very useful app mapping tools along with global.asax.

What I'm thinking of doing is actually using a URL rewrite method for challenging the web.sitemap xml file.  My issue is most of the content of my page is controled through a database, so I don't have many static pages at all.  The problem is that I want to include the database entries into the web.sitemap file so that I can update the XML whenever someone request the information to input all the database entries within the right sections.

I can already setup everything so that the .sitemap will be redirected to .net 2.0 and altered so it will show dynamic content, but where i'm struggling is getting into XML and learning how to change a specific node.

Example:

 

1    
2    <siteMap>
3     <siteMapNode title="Home" url="/">
4      <siteMapNode title="Search" url="/search/" />
5      <siteMapNode title="Title" url="/title/">
6    
7        <!-- This is where I want to input database entries such as:
8         <siteMapNode title="Title1" url="/title/1.info" />
9         <siteMapNode title="Title2" url="/title/2.info" />... etc -->
10   
11     </siteMapNode>
12    </siteMapNode>
13   </siteMap>
14   

 How do I do a search to find the siteMapNode for "Title" then go ahead and remove all current nodes, then go in and add new nodes?  Even if you have some good references, preferably VB.Net but I can decode C# if needed.

Also I want to do sitemap because I want to sort of trick the searchbots in a way to finding the entries a bit better, and so I can include a treeview node, somewhat like MSDN has.