Hello,
I am facing a wierd problem, I have an ultra wingrid whcih displays 15 bound coulmns. There are a few cells where the user can enter free text.
Now when the user enter some text into cell called "Notes" , moves to the next cell or clicks somewhere else (so that the focus is taken of this notes cell) and then if he clicks back into this "Notes" cell (which highlights all that has been previously typed) and uses the back space button to clear everything and again moves away from this cell, the previously entered value is retained.
This seems to happen only when I use backspace to clear the entire content which has been highlited by clicking into the cell.
any help would be greatly apprecaited.
Thanks
AJ
Nullable is an enum. Set it to Nothing (null) instead of DBNull.
I think I got the answer Mike, I will post the answer soon !!
Hello Mike,
Thanks for the quick response. You are right, the error was being suppressed in the event handler
private void dgItems_CellDataError(object sender, CellDataErrorEventArgs e) { e.RaiseErrorEvent = false; e.StayInEditMode = false; }
I commented out the above method. And I get the following error
"Unable to updat ethe data value: Object of type 'System.DBnull' cannot be converted to type 'System.String'"
Now the underlying property which binds to this column is of type "String", so I cannot make it nullable as it is already nullable.
Any other way i can get around this problem Mike ?
Thanks, Ashwin
Hi AJ,
The only thing that comes to mind is that the data source field does not allow nulls and and is rejecting the change. Or perhaps the grid is not trying to save the correct value for null.
Some data sources like null, some like DBNull.Value, and some only accept an empty string. The grid tries to figure out the right one to use when you blank out a cell, but it cannot always get it right, so you could try setting the Nullable property on the column and see if any of the options help.
If none of this helps, you might try setting the Visual Studio IDE to break on all run-time exceptions and see if there are any exceptions occurring when you leave the cell or the row.
If that still doesn't help, then perhaps you could duplicate the problem in a small sample project and post it here so I can take a look?