How to create sitemap runtime in asp.net

Axapta Code solutions Education and Entertainments Earn Money its Real Experience of knowledge


How to create sitemap runtime in asp.net

// begin program abc
// declare namespace
using System.Xml;
using System.Text;
using System.Data.SqlClient;
//declare class
public partial class sitemap : System.Web.UI.Page
{
    SqlConnection cn;
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            cn = new SqlConnection("Your connection string");
            string mydomain = "your domain name";
            string strSql = "select abc from test";
            SqlDataAdapter dacontent = new SqlDataAdapter(strSql, cn);
            DataSet dscontent = new DataSet();
            dacontent.Fill(dsd, "SiteMap");                     
                        //Now we are going to create XML file using XMLTextWriter
                       
            XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Encoding.UTF8);
            writer.WriteStartDocument();
            writer.WriteStartElement("urlset", "http://www.sitemaps.org/schemas/sitemap/0.9");
            writer.WriteStartElement("url");
            writer.WriteElementString("loc", "Your Domain Name");
            writer.WriteElementString("priority", "0.5");
            writer.WriteEndElement();
            if (dscontent.Tables[0].Rows.Count > 0)
            {
                DataRow dtr;
                int i = 0;
                while (i < dscontent.Tables[0].Rows.Count)
                {
                    dtr = dscontent.Tables[0].Rows[i];
                    writer.WriteStartElement("url");
                    writer.WriteElementString("loc", mydomain + "/" + dtr["abc"].ToString());
                    writer.WriteElementString("priority", "0.5");
                    writer.WriteEndElement();

                    i++;
                }
            }
            writer.WriteEndDocument();
            writer.Close();
        }
        catch (Exception ex)
        {
        }
    }
}

//end program