Loading

Convert dataset to xml

Satish

In my dataset,datetime column is there in that data is like "5/23/2017 1:13:43 PM"but after convert dataset to xml data is getting like "2017-05-23T13:13:43+05:30".How to avoid that datetime convertion.

Using this method:

return Content(ds.GetXml(), "text/xml");

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra9y ago
The getXML() changes the date format to UTC offset. You can use the following conversion code to convert UTC format string to any other DateTime format.

string result = Convert.ToDateTime("2017-05-23T13:13:43+05:30").ToString("MM/dd/yyyy h:mm:ss tt");

If you specify the datacolumn date time mode unspecified then it won't append that +5:30 hours.

myDateColumn.DateTimeMode = System.Data.DataSetDateTime.Unspecified