ContextQMD
Back to Devexpress

How to: Format Column Values Using Standard Format Strings

windowsforms-3047-controls-and-libraries-data-grid-examples-formatting-how-to-format-column-values-using-standard-format-strings.md

latest1.2 KB
Original Source

How to: Format Column Values Using Standard Format Strings

  • Nov 13, 2018

The following examples formats column values using standard format specifiers for date-time and numeric values.

The following image shows the result:

csharp
colOrderDate.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
colOrderDate.DisplayFormat.FormatString = "D";

colUnitPrice.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
colUnitPrice.DisplayFormat.FormatString = "c2";

colDiscount.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
colDiscount.DisplayFormat.FormatString = "P0";
vb
colOrderDate.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime
colOrderDate.DisplayFormat.FormatString = "D"

colUnitPrice.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric
colUnitPrice.DisplayFormat.FormatString = "c2"

colDiscount.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric
colDiscount.DisplayFormat.FormatString = "P0"