ASP.NET

public void GenerateXMLFile(string sFileName)
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["newcon"].ConnectionString);
    SqlCommand cmd = new SqlCommand("select * from CATEGORY ", con);
    //SqlCommand cmd1 = new SqlCommand("select * from PRODUCTS ",con);
    cmd.Connection.Open();
    //cmd1.Connection.Open();

    SqlDataReader reader1 = cmd.ExecuteReader();

    //Create XML

    Encoding enc = Encoding.UTF8;
    XmlTextWriter objXMLTW = new XmlTextWriter(sFileName, enc);
    try
    {
        objXMLTW.WriteStartDocument();//xml document open

        //'Top level (Parent element)
        //root node open
        objXMLTW.WriteStartElement("siteMap");

        //first Node of the Menu open
        objXMLTW.WriteStartElement("siteMapNode");

        //Title attribute set
        objXMLTW.WriteAttributeString("title", "Home");
        objXMLTW.WriteAttributeString("description", "This is home");//Description attribute set
        objXMLTW.WriteAttributeString("url", "~/index.aspx");//URL attribute set

        //Loop and create nodes

        while (reader1.Read())
        {
            int MasterID = reader1.GetInt32(0);
            objXMLTW.WriteStartElement("siteMapNode");
            objXMLTW.WriteAttributeString("title", reader1.GetString(1));
            objXMLTW.WriteAttributeString("description", reader1.GetString(5));
            objXMLTW.WriteAttributeString("url", reader1.GetString(11));


            objXMLTW.WriteEndElement();//Close the siteMapNode
        }
        objXMLTW.WriteEndElement();//Close the first siteMapNode
        objXMLTW.WriteEndDocument();//xml document closed
    }
    finally
    {
        objXMLTW.Flush();
        objXMLTW.Close();
        //cmd1.Connection.Close();
        cmd.Connection.Close();
    }
}