I retrieve date and time strings from xml by parsing XElement.
The date and time values are retrieved by
file.Element("Date").Value and file.Element("Time").Value respectively.
After I retrieve the Date value I parse it to a DateTime variable
DateTime dt,ts;
dt = file.Element("Date").Value; // the value is say 12/29/2012
and then this dt value is set to a datepicker value on the xaml UI
datepicker.Value = dt;
I also have a timepicker whose value have to be set by the Time value retrieved from xml. To set the timepicker value I do the following. declare 3 strings, say:
string a = file.Element("Time").Value; // the value is say 9:55 AM
string b = file.Element("Time").Value.Substring(0, 5) + ":00"; // eg 9:55:00
string c = file.Element("Time").Value.Substring(5); // the value is ' AM'
I then concatenate the Date Value and string 'b' and 'c'
string total = file.Element("Date").Value + " " + b + c;
the value of total is now '12/29/2012 9:55:00 AM'
I then try to Parse this total string to a DateTime, but it throws a formatexception
DateTime.Parse(total, CultureInfo.InvariantCulture);
Any help appreciated...
I have got the solution for this. When trying to save the datepicker in XML format, I was saving the value of timepicker as XMLElement as ValueString, hence when converted to string always throwed error. So I saved it in XML format as Value.ToString(). Now it can convert correctly from String to Date or Time equivalents.