I have a dataset bound to an ultragrid control. The column is a nullable integer in Oracle. I created a ValueList hooked to an UltraDropdown. When the database values are null the application displays blank in the column cell which is good. Now when I try the following code:
MyUltraGrid.ActiveCell.Value = null;
I get this message "Unable to convert from '(null)' to 'System.Decimal'. How do I programatically set the value to NULL in a dropdown valuelist cell. The Dropdown list does contains say 1, 2, 3, 4, 5 but no null value in the list.
The column DataType that is not changeable is "System.Decimal". Nullable is set to Automatic.
Resolved, I just needed to use DropDown rather than DropDownList.