Data Validation

When editing data in .Net Grid the the end user may enter erroneous data that cannot and should not be transferred to business logic objects. Instead, the grid has to display a user-friendly tip specifying the mistake and offering to edit erroneous data or to cancel editing.

Data Validation
Starting from version 2.5.0 .Net Grid offers a convenient data validation feature. To validate edited data it is sufficient to subscribe to Grid.ValidateCell event that provides data of the edited cell, new value that shall be transferred to business logic object and message that has to be displayed after editing. In this event one can also set an action instructing the grid of what has to be done after editing.

There are 4 possible actions:

  • ApplyValue - records a new value to the data object. If an exception is thrown during recording, Grid.ValidateCell event is generated one more time with clarifying information.
  • CancelValue - informs the grid that the new value doesn't have to be recorded to a data object. It is also possible to set a user-friendly message that will be displayed as a tooltip. If grid navigation is turned on (tab, tab+shift), the grid starts editing a new cell.
  • RestartEdit - Informs the grid that it has to restart editing current cell value. StopEdit - the new value is not recorded to the data object and the editing process is stopped. Unlike CancelValue, navigation between edited grid cells is ignored.

//Add handler to validate cells
grid.ValidateCell += OnValidateCell;

//Validation handler
private void OnValidateCell(object sender, Ui.ValidateCellEventArgs e)
//Default validation logic:
bool valid = e.Exception == null && string.IsNullOrEmpty(e.ErrorText);

//Add your validation logic here.
//valid = ...

if (!valid)
e.Action = ValidateCellAction.StopEdit;
e.ErrorText = "Please enter a valid value.";

Back to .Net Grid Features