SfDataGrid currentcellvalidation
12 Replies
Thank you for the video and the example. Let me review my code and I will update this thread with my observations.
-- updated --
Here is what I've got, since I cannot attach a document...
// here is my definition
public class METRIC
{
public class RECORD
{
public object UnitPrice { get; set; }
}
}
// the collection in which i store the data collected from the database, which is then added to the datasource for SfDataGrid
private readonly ObservableCollectionAllMetrics = new ObservableCollection ();
// my column definition for the affected column
{
SfDataGrid.Columns.Add(new GridTextColumn()
{
HeaderText = "UnitPrice",
MappingName = "UnitPrice",
CellStyle = new CellStyleInfo() { HorizontalAlignment = HorizontalAlignment.Right, VerticalAlignment = VerticalAlignment.Center },
MinimumWidth = 75,
AllowEditing = true,
AllowFiltering = false,
Visible = true
});
}
That is all of the code that I can supply at this time. If there is anything further that you require, please let me know.
I have also attached 2 pics. The first, showing the loaded value, 24.
The second pic showing an attempt to change 24 to 25 with the validation error message shown.
-----
Edit: I've also changed the SfDataGrid ValidtionMode to None, and I still get the error indicated if that helps. My understanding from this article, https://help.syncfusion.com/windowsforms/datagrid/datavalidation, was that validationmode of None meant that built-in validation is disabled. This appears to not be the case.
-----
Edit #2: If I change the type from:
public object UnitPrice { get; set; }
to:
public int UnitPrice { get; set; }
...I can edit the contents of the cell and validation works. Shouldn't type object accept anything in that cell/field?
-----
Edit #3: changing the column type from GridTextColumn to GridNumericColumn also results in "The input value is not a valid value for System.Object" error.
SIGN IN To post a reply.
