Handle Exception

Question

The DELETE statement conflicted with the REFERENCE constraint "FK_ASM_MASTER_DEPOT_MASTER1". The conflict occurred in database "FEDERAL_CNN", table "dbo.ASM_MASTER", column 'DepotCode'. The statement has been terminated.

Upendra Pratap Shahi · Answer

You can use exception handling using try{} catch{} block, it help you.

Sumit Joshi · Answer

Ok Priya Singh , I shows that your problem is Resolved ...Ok Thanks for asking the same in community

Priya Singh · Answer

catch (Exception ex) { if (ex.ToString().Contains("REFERENCE")) { oPeration = OperationResult.DeleteRefference; } else { this.dbManger.Close(); throw ex; } } i used this code through this code we can show message to the user and application also will be not termineted

Priya Singh · Answer

yes i have tryed both the things bt not found acceptable result

Sumit Joshi · Answer

Hi Priya Singh Have you tried both the things that we have mentioned if it works please accept i f helpful mark as Correct Answer

Manas Mohapatra · Answer

First resolve the issue. You can find my answer to resolve the problem. Is it resolved? As Sumit said you can use try-catch block to catch exception and show alert message that error is occurred. If any answer helped you please accept the answer and close.

Priya Singh · Answer

No yr Apllication will be hang u can not do other process after finding exception

Sumit Joshi · Answer

Hay Priya Singh , You can handle exception in Catch Block catch(Exception e) { } Your Application will not terminate

Priya Singh · Answer

Hi, Sumit Joshi u are saying right i can use try catch block but only you can find exception not handle

Sumit Joshi · Answer

Hi Priya Singh If You are facing this issue then you first have to deleate data references from Table M ASTER1 then delete the data from the table "dbo.ASM_MASTER", If you want to Handle Exception use Try Catch block in your Program code If helpful mark as Correct Answer

Manas Mohapatra · Answer

You are trying to Delete the record from a Table which has a reference in another Table. Here REFERENCE constraint is " FK_ASM_MASTER_DEPOT_MASTER1 ". In Database FEDERAL_CNN there are tables ASM_MASTER. DEPOT_MASTER1 and ASM_MASTER . DepotCode column is referenced by DEPOT_MASTER1 Table. So, you need to delete from DEPOT_MASTER1 Table first and then delete from Table ASM_MASTER . If you want to delete a row, then you have to execute the following two queries in sequence. DELETE FROM DEPOT_MASTER1 WHERE UserId = [UserIdToDelete]; DELETE FROM ASM_MASTER WHERE UserId = [UserIdToDelete];