Hopefully this is not a stupid question, but using a UltraWinGrid, if I have say a notes field, if I type something into that notes field, then click off the row to set it, then click on the cell and delete the text, it throws a popup:
Data Error
The value you entered is not valid, please try again
Is there a way to allow clearing values in an UltraWinGrid? I have been looking everywhere and cannot find how to do it.
Thanks
Hi,
It's unlikely that the grid is the issue here, it's most likely your data source that is rejecting the change.
What kind of data source are binding to the grid?
What is the data type of the Notes field?
Does the field allow nulls or DBNulls?
I am setting the Grid's to a manual schema, and on UltraGrid_InitializeRow, I am setting the data binding by using an object collection BindableList.
sorry, to clarify, on UltraGrid_InitializeRow, I am setting some of the columns to have a ValueList, and setting the datasource of that, and putting it into a DefaultEditorOwnerSettings for the cell.
In the Form Load, I am setting the data binding by using an object collection BindableList.
So you are binding the grid by setting it's DataSource property to a BindingList?
Ok... so what is the data type of the field for which the error is occurring? The grid allows nulls by default based on the data source settings. So if your data source is bound to a list of objects with properties that don't allow null, then that's probably the issue.