c# textbox decimal formatting

Question

I want my text boxes which are binded to money (SqlServer) entity fields, to show just two decimal places instead of four places.

I use DevExpress textEdit and CalcEdit boxes with the following display and edit format : "#,##0.00#;(#,##0.00#)"; But I always get four decimal places (zeros).

I use the same format string in Janus Grid, the values get display correctly.

Any Idea, thanks.

Answer 1

I would highly recommend using the built-in format strings wherever possible, such as N2.

string s = number.ToString("N2");

Use John Sheehan's .NET Format String Quick Reference Cheat Sheet when in doubt. It has all the info you need about formatting numbers and dates in .NET.

DevExpress controls usually require you to also specify what you are formatting (e.g. a number, date etc.):

calcEdit.Properties.DisplayFormat.FormatType = FormatType.Numeric;
calcEdit.Properties.DisplayFormat.FormatString = "N2";

If the format type isn't specified, the format string won't be applied.

With TextEdit you should specify a Mask instead.

textEdit.Properties.Mask.MaskType = MaskType.Numeric;
textEdit.Properties.Mask.EditMask = "N2";