How to create XML SiteMap Dynamically in ASP.Net

Today I am going to explain how to create XML SiteMap dynamically. I am using Visual Studio 2012 and MS SQL Database. For a large website, you cannot use any tool to create XML Sitemap by Accessing Database. So the best way to create a program to create XML SiteMap. Please follow my below code.

Namespace:

using System.Xml;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

Step1:
Create a website by opening the visual studio.I have named it as sitemap.aspx

Step2: 

Remove all lines from the aspx page and Paste the below line.

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="sitemap.aspx.cs" Inherits="WebApplication1.sitemap" ContentType ="text/xml" %>


Step 3: 

Double click on the aspx page and add all namespace written above.

Step 4:

Write the below code on page load event

Code:

2. try
3.             {
4.                 string cs = ConfigurationManager.ConnectionStrings[" write here your connection string name"].ConnectionString;
5.                 cn = new SqlConnection(cs);
6.                 string mydomain = "http://www.shrilekha.com"; // Write here your domain
7. 
   
8.                 string strSql = " write here your sql query example: Select * from businessTable";
9.                 SqlDataAdapter dacontent = new SqlDataAdapter(strSql, cn);
10.                 DataSet dscontent = new DataSet();
11.                 dacontent.Fill(dscontent, "SiteMap"); 
12. 
    
13.                 XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Encoding.UTF8);
14.                 writer.WriteStartDocument();
15.                 writer.WriteStartElement("urlset", "http://www.sitemaps.org/schemas/sitemap/0.9");
16. 
    
17.                 writer.WriteStartElement("url");
18. 
    
19.                 writer.WriteElementString("loc", "http://www.shrilekha.com");
20.                 writer.WriteElementString("priority", "0.5");
21.                 writer.WriteEndElement();
22. 
    
23.                 
24.                 if (dscontent.Tables[0].Rows.Count > 0)
25.                 {
26.                     DataRow dtr;
27.                     int i = 0;
28.                     while (i < dscontent.Tables[0].Rows.Count)
29.                     {
30.                         dtr = dscontent.Tables[0].Rows[i];
31. 
    
32.                         
33.                         writer.WriteStartElement("url");
34. 
    
35.                        
36.                         string bname = dtr["BusinessName"].ToString().Replace(" ","-").Replace("&","and").Replace(".","");
37. 
    
38. 
    
39.                         writer.WriteElementString("loc", mydomain +"/"+ bname.ToString());
40.                         writer.WriteElementString("priority", "0.5");
41. 
    
42.                         
43.                         writer.WriteEndElement();
44. 
    
45. 
    
46.                         i++;
47.                     }
48.                 }
49.                 writer.WriteEndDocument();
50.                 writer.Close();
51. 
    
52.             }
53.             catch (Exception ex)
54.             {
55. 
    
56.             }

Step: 5:
Run The project end enjoy.