I have a UltraNumericEditor (defined as below) that I use as the EditorControl for a UltraDataGrid cell. But when I try to leave the control empty I get the following error displayed:
DATA ERROR Unable to convert from '(null)' to 'System.Int32'
Definitionthis.uneCheckValues.Location = new System.Drawing.Point(767, 109); this.uneCheckValues.MaskClipMode = Infragistics.Win.UltraWinMaskedEdit.MaskMode.IncludeBoth; this.uneCheckValues.MinValue = 0; this.uneCheckValues.Name = "uneCheckValues"; this.uneCheckValues.Nullable = true; this.uneCheckValues.PromptChar = ' '; this.uneCheckValues.TabIndex = 16; this.uneCheckValues.Visible = false;
Entry in the cell is not required, so how can I allow for nulls (if no entry)?
Hi,
What kind of DataSource are you using? If you are using a DataSource that does not allow nulls, then obviously the grid cannot allow nulls either.
Hi Mike.
I have encountered the same issue.
I can confirm the DataType of the column is "double* NOT nullable.
Do you have a solution for it?
Thanks.
Hm, okay. If you are using a DataSet, then it should allow DBNull. You might try looking at the Nullable property of the column and see if that helps.
If not, I recommend reporting the issue to Infragistics Developer Support. Send along a small sample project demonstrating the behavior you are getting so they can check it out.
Submit a Support Issue
The DataSource is set to a function that returns a type of System.Data.DataSet - this function calls the stored proc I described.
You seem to be talking about the database here. What is the grid's DataSource set to?