Formatting a Field | Infragistics Forums

185

Formatting a Field

Rich posted over 16 years ago

Might be quite a simple question, I have bound a XamDataGrid to a SQL Server view, one field is a quantity, stored as a decimal in the DB. When the Grid displays it, its default format is to show this decimal value as currency, but we only need it to show a decimal value without leading currency symbol.

Having spent all day in FieldLayouts, FieldLayoutSettings and FieldSettings I'm still none the wiser.

Any help greatly appreciated, thanks!

10

Mark posted over 16 years ago

it would seem decimal data types are displayed in the xamcurrencyeditor, and double data type displayed in xamnumbereditor.

Just convert your decimal data to double, and it gets rid of the currencies.
Cancel
Reply

Cancel
10

Mark posted over 16 years ago

According to the api the xamcurrencyeditor is used on decimal data type or xamnumbereditor is used on double data type

could look at converting data types.
Cancel
Reply

Cancel
8576

Offline Joe Modica posted over 16 years ago in reply to Robson

Hi Robson -

The ValueEditor class in the Infragistics.Windows.Editors namespace exposes a static RegisterDefaultEditorForType method that lets you associate a particular editor type with a specific data type, to replace any previously registered (or the default) editor for that type. However, you cannot set any properties on the supplied editor type (e.g., Mask).

What you can do though is listen to the XamDataGrid's FieldLayoutInitialized event and iterate through all the Fields in the FieldLayout's Fields collection looking for Fields with a numeric DataType. For each one you find, simply set its EditorStyle as described in the earlier post.

Joe Modica
Cancel
Reply

Cancel
435

Robson posted over 16 years ago in reply to Joe Modica

I have my grid bound to a datasource, so my columns are created automatically and I don't have a specific Field configuration for each column. Is there a way I can change the EditorType for all numeric columns? I figured there must be a way to do it by defining a styleStyle style = new Style(typeof(Field));style.Setters.Add(new Setter(Field.EditorType, typeof(XamMaskedEditor)));this.ResultSetDataGrid.Resources.Add("NumericFeildStyle", style); But it doesn't seem like EditorType is a dependency property. The other problem with this is that it doesn't target numeric columns directly.Any ideas?Thanks,Robson
Cancel
Reply

Cancel
185

Rich posted over 16 years ago in reply to Joe Modica

Hi Joe,
Really appreciate your reply. I had a feeling it would be something as simple as that!
Cancel
Reply

Cancel