First off, I am on version 2010.3.1314.35 and cannot upgrade at this time. When using a GridView with a column bound to a
System.Nullable<double> property, I have a couple issues. One issue is that it allows the user to type anything in the field. Not just decimal numbers. I tried to solve this by using cell validating, but when I type a character and tab out of the field, before validating fires it tries to update the bound item (2 way binding is on) and throws a format exception because the character value cannot be put into the double? property.
The other issue is, since it is nullable, I would also like to allow the user to leave the field blank and it assign null to the bound property. Is this possible or am I going to have to unbind the column and manually update accordingly?