troubleshooting Question

Put timestamp on XML file and delete after specific interval.

Avatar of Johny Bravo
Johny Bravo asked on
.NET ProgrammingASP.NETXML
1 Comment1 Solution582 ViewsLast Modified:
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)
            {
 
            }
ASKER CERTIFIED SOLUTION
VikramMullick

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros