Hi,
We are using Infragistics2.Win.UltraWinGrid.v10.3
We are currently binding a datatable to the UltraWinGrid control. The datatable has a numeric column with default value set to zero.Hence whenever the grid is displayed the column contains a Zero value.
Query:
Is there any method or property available in the UltraWinGrid that will allow us to display an Empty String to the user if the column has a Zero value without affecting the datatable , as there are few complex calculations that take place on the basis of the column value ?
Thanks !
The easiest thing to do would be to set the value of the field in the DataTable to DBNull.Value, instead of 0.
If that's no good, then you might want to see if the data type of your column supports any format that will display a blank instead of a 0.
Standard Numeric Format Strings
Custom Numeric Format Strings
If so, you can use the Format property of the column. If not, then you would have to explore some more complex options like a DataFilter or a DrawFilter. How difficult this is depends a lot on whether the field can be edited by the user.