Avatar of Johny Bravo
Johny Bravo
 asked on

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)
            {
 
            }

Open in new window

.NET ProgrammingASP.NETXML

Avatar of undefined
Last Comment
VikramMullick

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
VikramMullick

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck