Category / Section
How to show normal MessageBox instead of showing default ErrorMessageBox for DataValidation?
To avoid the default error message box and display the normal message box, use the Cancel property and TableControlCurrentCellErrorMessage event.
//Event Subscription.
this.gridGroupingControl1.TableControlCurrentCellErrorMessage += newGridTableControlCurrentCellErrorMessageEventHandler(gridGroupingControl1_TableControlCurrentCellErrorMessage);
void gridGroupingControl1_TableControlCurrentCellErrorMessage(object sender, GridTableControlCurrentCellErrorMessageEventArgs e)
{
//to cancel showing the default ErrorMessageBox support.
e.Inner.Cancel = true;
//To get the orginal error from e.Inner.Text
DialogResult result = MessageBox.Show(e.Inner.Text, "ErrorProvider", MessageBoxButtons.OKCancel);
if (result == DialogResult.Cancel)
{
e.TableControl.CurrentCell.CancelEdit();
}
}'Event Subscription.
AddHandler Me.gridGroupingControl1.TableControlCurrentCellErrorMessage,
AddressOf gridGroupingControl1_TableControlCurrentCellErrorMessage
Private Sub gridGroupingControl1_TableControlCurrentCellErrorMessage(ByVal sender As Object, ByVal e As GridTableControlCurrentCellErrorMessageEventArgs)
'to cancel showing the default ErrorMessageBox support.
e.Inner.Cancel = True
'To get the original error from e.Inner.Text
Dim result As DialogResult = MessageBox.Show(e.Inner.Text, "ErrorProvider", MessageBoxButtons.OKCancel)
If result = DialogResult.Cancel Then
e.TableControl.CurrentCell.CancelEdit()
End If
End Sub The
screenshot below displays the data validation error message.

Sample Links: