{"id":4366,"date":"2015-06-22T07:05:22","date_gmt":"2015-06-22T07:05:22","guid":{"rendered":"http:\/\/a1webdesignteam.com\/blog\/?p=4366"},"modified":"2015-06-22T07:05:22","modified_gmt":"2015-06-22T07:05:22","slug":"create-a-sitemap-with-asp-net","status":"publish","type":"post","link":"https:\/\/a1webdesignteam.com\/blog\/create-a-sitemap-with-asp-net\/","title":{"rendered":"Create a SiteMap with ASP.NET"},"content":{"rendered":"
\n

What are Sitemaps?<\/h1>\n

Sitemaps are an easy way for webmasters to inform search engines about pages on their sites that are available for crawling. In its simplest form, a Sitemap is an XML file that lists URLs for a site along with additional metadata about each URL (when it was last updated, how often it usually changes, and how important it is, relative to other URLs in the site) so that search engines can more intelligently crawl the site.
\nSitemap tag definitions<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n
Tag<\/strong><\/td>\nRequired?<\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n
<urlset><\/code><\/td>\nRequired<\/td>\nEncloses all information about the set of URLs included in the Sitemap.<\/td>\n<\/tr>\n
<url><\/code><\/td>\nRequired<\/td>\nEncloses all information about a specific URL.<\/td>\n<\/tr>\n
<loc><\/code><\/td>\nRequired<\/td>\nSpecifies the URL. For images and video, specifies the landing page (aka play page, referrer page). Must be a unique URL.<\/td>\n<\/tr>\n
<lastmod><\/code><\/td>\nOptional<\/td>\nThe date the URL was last modifed, in YYYY-MM-DDThh:mmTZD format (time value is optional).<\/td>\n<\/tr>\n
<changefreq><\/code><\/td>\nOptional<\/td>\nProvides a hint about how frequently the page is likely to change. Valid values are:<\/p>\n
    \n
  • always<\/code>. Use for pages that change every time they are accessed.<\/li>\n
  • hourly<\/code><\/li>\n
  • daily<\/code><\/li>\n
  • weekly<\/code><\/li>\n
  • monthly<\/code><\/li>\n
  • yearly<\/code><\/li>\n
  • never. <\/code> Use this value for archived URLs.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n
<priority><\/code><\/td>\nOptional<\/td>\nDescribes the priority of a URL relative to all the other URLs on the site. This priority can range from 1.0 (extremely important) to 0.1 (not important at all).Does not affect your site\u2019s ranking in Google search results. Because this value is relative to other pages on your site, assigning a high priority (or specifying the same priority for all URLs) will not help your site\u2019s search ranking. In addition, setting all pages to the same priority will have no effect.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Sitemap Example<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
01<\/div>\n
02<\/div>\n
03<\/div>\n
04<\/div>\n
05<\/div>\n
06<\/div>\n
07<\/div>\n
08<\/div>\n
09<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
<?<\/code>xml<\/code> version<\/code>=<\/code>\"1.0\"<\/code> encoding<\/code>=<\/code>\"UTF-8\"<\/code>?><\/code><\/div>\n
<<\/code>urlset<\/code> xmlns<\/code>=<\/code>\"http:\/\/www.sitemaps.org\/schemas\/sitemap\/0.9<\/a>\"<\/code>><\/code><\/div>\n
\u00a0\u00a0<\/code><<\/code>url<\/code>><\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code><<\/code>loc<\/code>>http:\/\/www.a1webdesignteam.com\/<\/a><\/<\/code>loc<\/code>><\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code><<\/code>lastmod<\/code>>2012-01-01<\/<\/code>lastmod<\/code>><\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code><<\/code>changefreq<\/code>>monthly<\/<\/code>changefreq<\/code>><\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code><<\/code>priority<\/code>>0.8<\/<\/code>priority<\/code>><\/code><\/div>\n
\u00a0\u00a0<\/code><\/<\/code>url<\/code>><\/code><\/div>\n
\u00a0\u00a0<\/code><<\/code>url<\/code>><\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code><<\/code>loc<\/code>>http:\/\/www.a1webdesignteam.com\/about-me\/<\/a><\/<\/code>loc<\/code>><\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code><<\/code>priority<\/code>>0.5<\/<\/code>priority<\/code>><\/code><\/div>\n
\u00a0\u00a0<\/code><\/<\/code>url<\/code>><\/code><\/div>\n
<\/<\/code>urlset<\/code>><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

First, We need to create table or store procedure to get url from sites.
\nHere I created on table named GoogleIndexProduct with two column : URl and UpdatedDate
\nNow I used Following code to generate SiteMap xml file from that created table.
\nSiteMap.aspx.cs:<\/strong><\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
01<\/div>\n
02<\/div>\n
03<\/div>\n
04<\/div>\n
05<\/div>\n
06<\/div>\n
07<\/div>\n
08<\/div>\n
09<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n
49<\/div>\n
50<\/div>\n
51<\/div>\n<\/td>\n
\n
\n
using<\/code> System;<\/code><\/div>\n
using<\/code> System.Collections.Generic;<\/code><\/div>\n
using<\/code> System.Linq;<\/code><\/div>\n
using<\/code> System.Web;<\/code><\/div>\n
using<\/code> System.Web.UI;<\/code><\/div>\n
using<\/code> System.Web.UI.WebControls;<\/code><\/div>\n
using<\/code> System.Data.SqlClient;<\/code><\/div>\n
using<\/code> System.Xml;<\/code><\/div>\n
using<\/code> System.Text;<\/code><\/div>\n
\u00a0<\/code><\/div>\n
public<\/code> partial<\/code> class<\/code> SiteMap: System.Web.UI.Page<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>protected<\/code> void<\/code> Page_Load(<\/code>object<\/code> sender, EventArgs e)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Response.Clear();<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Response.ContentType = <\/code>\"text\/xml\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>using<\/code> (XmlTextWriter writer = <\/code>new<\/code> XmlTextWriter(Response.OutputStream, Encoding.UTF8))<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>writer.WriteStartDocument();<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>writer.WriteStartElement(<\/code>\"urlset\"<\/code>);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>writer.WriteAttributeString(<\/code>\"xmlns\"<\/code>, <\/code>\"http:\/\/www.sitemaps.org\/schemas\/sitemap\/0.9<\/a>\"<\/code>);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>string<\/code> connect = WebConfigurationManager.ConnectionStrings[<\/code>\"MyConnString\"<\/code>].ConnectionString;<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>using<\/code> (SqlConnection con = <\/code>new<\/code> SqlConnection(connect))<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>con.Open();<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>string<\/code> query = <\/code>\"SELECT [URL],Date FROM [GoogleIndexProduct]\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>SqlCommand cmd = <\/code>new<\/code> SqlCommand(query, con);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>SqlDataReader dr = cmd.ExecuteReader();<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>while<\/code> (dr.Read())<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>writer.WriteStartElement(<\/code>\"url\"<\/code>);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>writer.WriteElementString(<\/code>\"loc\"<\/code>, dr[0].ToString());<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>writer.WriteElementString(<\/code>\"lastmod\"<\/code>, String.Format(<\/code>\"{0:yyyy-MM-dd}\"<\/code>, dr[1]));<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>writer.WriteElementString(<\/code>\"changefreq\"<\/code>, <\/code>\"weekly\"<\/code>);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>writer.WriteElementString(<\/code>\"priority\"<\/code>, <\/code>\"1.0\"<\/code>);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>writer.WriteEndElement();<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>con.Close();<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>con.Dispose();<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>writer.WriteEndElement();<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>writer.WriteEndDocument();<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>writer.Flush();<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Response.End();<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

SiteMap.aspx:<\/strong>
\nThe first thing I did when adding the page to the site was to remove all but the top line of the aspx file. This prevents any html being added to the response and invalidating the xml of the sitemap. All that appears, therefore is:<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
<%@ Page Language=\"C#\" AutoEventWireup=\"true\" CodeFile=\"SiteMap.aspx.cs\" Inherits=\"SiteMap\" %><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

What are Sitemaps? Sitemaps are an easy way for webmasters to inform search engines about pages on their sites that are available for crawling. In its simplest form, a Sitemap is an XML file that lists URLs for a site along with additional metadata about each URL (when it was last updated, how often it […]<\/p>\n","protected":false},"author":1,"featured_media":4367,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"categories":[32],"tags":[51],"_links":{"self":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts\/4366"}],"collection":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/comments?post=4366"}],"version-history":[{"count":0,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts\/4366\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/media\/4367"}],"wp:attachment":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/media?parent=4366"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/categories?post=4366"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/tags?post=4366"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}