Handle Exception

Priya Singh

11y1.1k

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.

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
You can use exception handling using try{} catch{} block, it help you.
0
Sumit Joshi11y ago
Ok Priya Singh , I shows that your problem is Resolved ...Ok Thanks for asking the same in community
0
Priya Singh11y ago
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
0
Priya Singh11y ago
yes i have tryed both the things bt not found acceptable result
0
Sumit Joshi11y ago
Hi Priya Singh

Have you tried both the things that we have mentioned if it works please accept

if helpful mark as Correct Answer
0
Manas Mohapatra11y ago
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.
0
Priya Singh11y ago
No yr Apllication will be hang u can not do other process after finding exception
0
Sumit Joshi11y ago
Hay Priya Singh ,

You can handle exception in Catch Block
catch(Exception e)
{

}

Your Application will not terminate
0
Priya Singh11y ago
Hi,
Sumit Joshi

u are saying right i can use try catch block but only you can find exception not handle
0
Sumit Joshi11y ago
Hi Priya Singh

If You are facing this issue then you first have to deleate data references from Table MASTER1 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
0
Manas Mohapatra11y ago
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];
0