how to Handle violating constaints error message in griddatabound

Hello I set the primiary keys of datasource to control duplicate row entry in my grid. if the user enters a duplicate value for the primary key column, they get a built in error generated by the grid itself warning them of this error. Do you know how I can stop this message and use my messagebox ? is there any events I can catch?

Hi Yang, you can handle the groupingControl.ExceptionRaised event and set e.Cancel = true. Then you can display your own messagebox there. Stefan

If this is a GridDataBoundGrid, then try handling the grid''s ValidateFailed event. There to provide your own message, set grid.CurrentCell.ErrorMessage.

private void gridDataBoundGrid1_ValidateFailed(object sender, GridValidateFailedEventArgs e)
{
	this.gridDataBoundGrid1.CurrentCell.ErrorMessage = "My message";
}

Hi Clay, This works fine if the user key-in invalid value and leave the cell either by pressing Tab or arrow button or mouse. But fails if Enter key is hit i.e. if the user hit Enter key after invalid value then same Grid''s buil-in error message is show. In clue on how to handle this. Regards, Shahzad

One thing that might work is to catch the Enter key and turn it into a Tab key. You can do this by handling the CurrentCellKeyDown event.

private void gridDataBoundGrid1_CurrentCellKeyDown(object sender, KeyEventArgs e)
{
	if(e.KeyCode == Keys.Enter)
	{
		e.Handled = true;//ignore Enter
		SendKeys.Send("{TAB}");//do a tab
	}
}

Thanks Clay.It work''s fine!!!