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.CommandType = CommandType.StoredProcedure;
        sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        sqlCmd.Connection = sqlCon;
        // sqlCmd.Parameters.Add(new SqlParameter("All (With No POD)","",""));
        SQLXMLReader1 = sqlCmd.ExecuteXmlReader();
            StringBuilder xmlData = new StringBuilder();
            while (SQLXMLReader1.Read())
                XmlDocument xmlDoc = new XmlDocument();
                //XmlElement rootNode = xmlDoc.CreateElement("markers");
                // xmlDoc.LoadXml("<markers >" + xmlData.ToString() + "</markers>");
            catch (Exception ex1)

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