Duplicate Entries in Grid

[Administrator]

I am using a GridDataBoundGrid, with a DataTable as the DataSource. In the DataTable, i set the primary key field to prevent duplicate entries. Is there a way I can trap the duplicate key exception before it is thrown up to the user?

[Administrator]

Hi Michael,

Yes. You can handle the CurrentCellErrorMessage event and display your own error message whenever the grids CurrentCell.DisplayWarningText (as a result of some kind of validation error) is called.

private void grid_CurrentCellErrorMessage(object sender, GridCurrentCellErrorMessageEventArgs e)
{
MessageBox.Show(e.Text,"CurrentCell Error",MessageBoxButtons.OKCancel,MessageBoxIcon.Error );
e.Cancel = true;
}

Let me know if you face any issues when implementing the above.

Best Regards,
Haneef