I am using this event (BeforeCellUpdate) to validate user grid entry and e.cancel=true if violation found and exiting event. Works Ok in general. However I am having issue with numeric columns and nulls, for example user need abilities to null current cell value and leave it blank. Your grid instead of null applying 0, we would like to know what would be best to do so besides using text type instead of numeric for column. Thanks!
UltraGridColumn exposes a Nullable property which gives you a way to specify what value is sent back to the data source when a cell's contents are cleared. You can set this to (for example) 'Null', but the fact that the column did not automatically pick that value up leads me to believe that the underlying DataColumn is not nullable (AllowDBNull returns false), in which case there will be an error when the cell is updated.
Thanks, we are using typed datasets where column set to System.Double and I can't change property NullValue to anything besides default (Throw exception). Using other datatypes for column wouldn't be good I believe, I prefer to match dataset and grid columns datatypes especially when important calculations performed by grid.