CONVERTING DATE TO dd/mm/yyyy IN XML

Question

Hello All I need your help friends I wrote a code that will extract records from SQL TABLE and use dataset to write it to XML  but i encounter a date convertion challenge after writting the XML the date change from dd/mm/yyyy to yyyy-mm-ddT00:00:00+00  in the process of correcting this i found this code www.c-sharpcorner.com //XMLTextReader //Reads the Xml data generated by DataSet XmlTextReader XTReader = new XmlTextReader(ds1.GetXml() XmlNodeType.Element null); //XMLTextWriter //To write data into xml file XmlTextWriter XTWriter = new XmlTextWriter(directoryPath + Tfilename.Trim() + .xml Encoding.UTF8); XTWriter.WriteStartDocument(); string fieldName = ; while (XTReader.Read()) { switch (XTReader.NodeType) { //Check for the Node Name case XmlNodeType.Element: XTWriter.WriteStartElement(XTReader.Name); fieldName = XTReader.Name; break; //Check for the Node Value case XmlNodeType.Text: //If the NodeName is PubDate string Fname = ; foreach (string mList in mFieldname) { Fname = mList.ToString().ToLower(); if (fieldName.ToLower() == Fname) break; } if (fieldName.ToLower() == Fname) //if (fieldName.ToLower() == SearchDate.ToLower()) { DateTime dt = DateTime.Parse(XTReader.Value.ToString()); //Here the DateTime can be changed to any format as //MM-dd-yyyy or dd-MM-yyyy or .ToShortDateString() ... XTWriter.WriteString(dt.ToString(dd/MM/yyyy)); } else XTWriter.WriteString(XTReader.Value); // break; //} break; case XmlNodeType.EndElement: XTWriter.WriteEndElement(); break; } //switch } // while XTWriter.Close(); this code worked fine in converting the date to british-UK format The issue now is it is changing the XML file from vertical arrengment to horizontal making hard to read bellow is the result: Hidden Hidden Yes MARRIED Null 263 Male 11/01/1976 40 Null Employed Junior Secondary UDI ENUGU ENUGU IBO 1416110036 02371 28/05/2015 16 Null 01/01/1999 NO 6 01/07/2015 5988 Hidden Hidden Yes MARRIED Null 574 Male 11/04/1979 36 Null Employed Junior Secondary AWKUNTO UDI ENUGU ENUGU IBO 1416110036 02348 28/04/2015 16 Null 01/01/1999 NO 6 24/11/2015 5916 Hidden Hidden Yes MARRIED Null 784 Female 01/03/1990 26 Null Employed Junior Secondary UDI ENUGU ENUGU IBO 1416110036 02287 17/02/2015 16 Null 01/01/1999 NO 6 20/10/2015 6470 Hidden Hidden Yes MARRIED Null 842 Male 15/05/1985 30 Null Employed Junior Secondary ATANI AROCHUKWU UDI IMO IMO IBO 1416110036 01549 01/11/2011 16 Null 01/01/1999 NO 6 21/07/2015 4690

Abraham Olatubosun · Answer

Thanks Joginder Banger i have taken that option earlier before But my challenge is no more date conversion but the arrangement of the XML Element and nodes also the script is repeating the closing Tag ( represent the closing Tag with RED in my last post). regards

Joginder Banger · Answer

Hi you have option in sql you can convert date change as per requirement. convert('your values'113) for more information check this link http://www.w3schools.com/sql/func_convert.asp