int mySalary = 123456;
string.Format("{0:C}",
mySalary); // $123,456.00
string.Format("{0:D}",
mySalary); // 123456
string.Format("{0:E}",
mySalary); // 1.234560E+005
string.Format("{0:F}",
mySalary); // 123456.00
string.Format("{0:G}",
mySalary); // 123456
string.Format("{0:N}",
mySalary); // 123,456.00
string.Format("{0:X}",
mySalary); // 1E240
string.Format("{0:#%}",
mySalary); // 12345600%
string.Format("{0:#,###}",
mySalary); // 123,456
string.Format("{0:#,###.00}",
mySalary); // 123,456.00
string.Format("{0:#,###.##}",
mySalary); // 123,456
string.Format("{0:'$'#,###.00}",
mySalary); // $123,456.00
string.Format("{0:#,###' lbs'}",
mySalary); // 123,456 lbs
mySalary = -123456;
string.Format("{0:#0}",
mySalary); // -123456
string.Format("{0:#0;(#0)}",
mySalary); // (123456)
If you need to save today's date in the XSD:DateTime format use the following format:
DateTime.Now.ToString("yyyy-MM-ddTHH:MM:ss");
// 2008-01-17T17:08:46.
APA date retrieved
DateTime.Today.ToString("MMMM yyyy, dd") // October 2011, 19