there is 3 queries:
query 1: Negative values are coming for "TotalOutright" column, i don''t want values like {97,731} but -93,731.
i m doing like this: pls see below code
GridColumnDescriptor col = new GridColumnDescriptor();
col.Name = name;
col.HeaderText = displayText;
col.MappingName = mappingName;
col.Appearance.AnyRecordFieldCell.CellType = "Currency";
col.Appearance.AnyRecordFieldCell.HorizontalAlignment = GridHorizontalAlignment.Right;
col.Appearance.AnyRecordFieldCell.CurrencyEdit.CurrencySymbol = "";
col.Appearance.AnyRecordFieldCell.CurrencyEdit.CurrencyDecimalDigits = 0;
col.Appearance.AnyRecordFieldCell.CurrencyEdit.NegativeSign = "-";
col.Appearance.AnyRecordFieldCell.CurrencyEdit.CurrencyGroupSeparator = ",";
query 2: "TotalCollaterate" column cell values should be "blue" not black.
i am doing like this, pls see the below code, and i don''t want to use event "gridGroupingControl1_QueryCellStyleInfo"
GridColumnDescriptor col = new GridColumnDescriptor();
col.Name = name;
col.HeaderText = displayText;
col.MappingName = mappingName;
col.Appearance.AnyRecordFieldCell.CellType = "Currency";
col.Appearance.AnyRecordFieldCell.HorizontalAlignment = GridHorizontalAlignment.Right;
col.Appearance.AnyRecordFieldCell.CurrencyEdit.CurrencySymbol = "";
col.Appearance.AnyRecordFieldCell.CurrencyEdit.CurrencyDecimalDigits = 0;
col.Appearance.AnyRecordFieldCell.CurrencyEdit.NegativeSign = "-";
col.Appearance.AnyRecordFieldCell.CurrencyEdit.CurrencyGroupSeparator = ",";
col.Appearance.AnyRecordFieldCell.Control.ForeColor = Color.Blue;
query 3: In "RecDate" column, i made column type "datetime", but if there is null data coming for any row, it is showing 01-01-0001, i don''t want that if data is null nothing will come as well as i don''t want dropdown sign.
i am doing like this: pls see below code and i don''t want to use event "gridGroupingControl1_QueryCellStyleInfo"
GridColumnDescriptor col = new GridColumnDescriptor();
col.Name = name;
col.HeaderText = displayText;
col.MappingName = mappingName;
col.Appearance.AnyRecordFieldCell.Format = "dd-MM-yyyy";
col.Appearance.AnyRecordFieldCell.CellValueType = typeof (DateTime);
col.Appearance.AnyRecordFieldCell.HorizontalAlignment = GridHorizontalAlignment.Right;
untitled24.zip