Forum

Hi,

Can somebody show me how to use the ValidateEditingCellData event? Is it the right tool for validating user input e.g in a text edit cell?

Here is a simple C# project that illustrates the issue. Please build and run the application. You will see that if you type a space in any cell in the Name column, the value will not be committed to the bound data. This is achieved because the ValidateEditingCellData event is handled in this way:

private void boundGridControl1_ValidateEditingCellData(object sender, 
   Elegant.Grid.ValidateCellDataEventArgs e)
{
   if(e.Cell.Column != NameColumn)
       return;

   if(e.ValidationReason == DataValidationReason.BeforeCommit &&
       e.DataValue.ToString().IndexOf(’ ’) != -1)
   {
       e.InvalidDataBehavior = CellInvalidDataBehavior.None;
       e.Valid = false;

       MessageBox.Show("The name cannot contain spaces.");
   }
}

If you mean something else, just contact us and we will help you find the most appropriate solution.

Many thanks. Works like a dream!