Put timestamp on XML file and delete after specific interval.

Hi Experts,

I am creating a xml file with C# code.I want to put a timestamp on that file and delete it after specific interval.

XmlReader SQLXMLReader1;
 
        sqlCmd = new SqlCommand();
        //sqlCmd.CommandText = "getShipmentsStatuses_TEST";
        sqlCmd.CommandText = "getShipmentsStatuses";
 
 
        string frmdt = this.dpFromDate.TextValue;
        string todt = this.dpToDate.TextValue;
        string pod = this.ddlPODStatus.SelectedItem.Text;
 
        sqlCmd.Parameters.Add(new SqlParameter("@Deliverystatus", pod));
        sqlCmd.Parameters.Add(new SqlParameter("@filterDate_from", frmdt));
        sqlCmd.Parameters.Add(new SqlParameter("@filterDate_to", todt));
 
 
        //sqlCmd.CommandText="GetXML";
        sqlCmd.CommandType = CommandType.StoredProcedure;
 
        sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
 
        sqlCmd.Connection = sqlCon;
 
        sqlCon.Open();
 
        // sqlCmd.Parameters.Add(new SqlParameter("All (With No POD)","",""));
 
 
        SQLXMLReader1 = sqlCmd.ExecuteXmlReader();
 
        
 
            StringBuilder xmlData = new StringBuilder();
 
            while (SQLXMLReader1.Read())
            {
                xmlData.Append(SQLXMLReader1.ReadOuterXml());
 
            }
            //Console.WriteLine(xmlData.ToString());
            //Response.Write(xmlData.ToString());
 
            try
            {
                XmlDocument xmlDoc = new XmlDocument();
 
                //XmlElement rootNode = xmlDoc.CreateElement("markers");
 
                //xmlDoc.DocumentElement.AppendChild(rootNode);
 
 
                xmlDoc.LoadXml(xmlData.ToString());
 
 
 
                // xmlDoc.LoadXml("<markers >" + xmlData.ToString() + "</markers>");
 
 
                xmlDoc.Save("D:/Amit_new/GoogleApi/ShipmentStat.xml");
 
                sqlCon.Close();
            }
            catch (Exception ex1)
            {
 
            }

Select allOpen in new window