I stared working on my sitemap tonight. Never done the SiteMap stuff before. Opened my Pro ASP.NET 2.0 in C# 2005 that I use as a jump off point for intro topics I haven't touched yet. The chapter is great but I like my data in the database which gets backed up every night. I understood enough and even got a test page up using nested site map files. Hurray!
Now on to the SQL provider. I knew there had to be one so I googled and found an article with code by Jeff Prosise. The article covers the .cs file that is the SQL provider, as well as the web.config changes, the T-SQL, and the aspnet_regsql commands.
After you get the provider up and working, don't expect the SQL provider to show up in the Data Source Configuration Wizard:
You'll have the change the SiteMapDataSource to specify the Provider that you added to the web.config for SQL:
asp:SiteMapDataSource ID="TotalSiteMap" runat="server" SiteMapProvider="AspNetSqlSiteMapProvider" /><
But now my data is in the database and I changed the proc to be NetTiers-compliant so I can use their Admin pages for my data management.
No comments:
Post a Comment