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!
I should probably add that this:
myField.DataType = typeof(decimal);
still gives the currency-formatted version.
myField.DataType = typeof(string);
actually prevents ANYTHING from loading, i.e. we get an empty datagrid.
I have resolved this issue now:
myField.Settings.EditorType = typeof(Infragistics.Windows.Editors.XamTextEditor);
I had been overlooking the Editxxxxxxx properties as I thought they would be only used when the field/cell was being edited.