How can I capture the Sql error 547 in Entity Data Source

jeffrianwar · December 28th, 2011, 12:29 PM

Dear All,

Need your assistance
I am trying to capture this error 547 (The DELETE statement conflicted with the REFERENCE constraint "FK_iCategorySub_iCategory") and informing the user that this record has associated record in another table. FYI I am using Entity Data Source for my List View. In SQL Data Source I could use “SqlDataSourceStatusEventArgs” and it works successfully.

Many thanks and best regards

Imar · December 29th, 2011, 03:58 AM

Hi there,

You can handle the Deleted event of the ODS and then look at the InnerException of the Exception property on the e argument. Something like this should do the trick:

Code:

protected void EntityDataSource1_Deleted(object sender, EntityDataSourceChangedEventArgs e)
{
  if (e.Exception != null && e.Exception.InnerException != null && e.Exception.InnerException is SqlException)
  {
    SqlException myException = (SqlException)e.Exception.InnerException;
    if (myException.Number == 547)
    {
      ErrorMessage.Text = @"Sorry, you can't delete this record because it has associated records that you need to delete first.";
      e.ExceptionHandled = true;
    }
  }
}

Hope this helps,

Imar

jeffrianwar · December 29th, 2011, 06:20 AM

Dear Imar,

Many thanks, sure it help.

Take care, you have a great week-end and happy new year...