Click here to Skip to main content
15,895,084 members
Search within:


Violation of PRIMARY KEY constraint 'PK__booking1__03317E3D'. Cannot insert duplicate key in object 'dbo.booking1'. The statement has been terminated.
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
ASP.NET
Hello Sir ,

I was getting Error When i saved button entered error displayed i.e :: Violation of PRIMARY KEY constraint 'PK__booking1__03317E3D'. Cannot insert duplicate key in object 'dbo.booking1'. The statement has been terminated.

Please ASAP reply with full solution .<b></b>
Posted
Add a Solution

2 solutions

you are trying to insert a duplicate key where the key field is declared

as primary key.

check the primary key of the table and eliminate the insertion of the duplicate key
 
Share this answer
 
Posted
Dear Friend
I have a datatable that contain 5 records, These 4 records r also in the database here i m getting an error.Violation of PRIMARY KEY constraint 'PK_inventory'. Cannot insert duplicate key in object 'dbo.inventory'.
The statement has been terminated.
Regard
Priya
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
How to solve violation of PRIMARY KEY constraint 'PK_teacher'. Cannot insert duplicate key in object 'dbo.teacher' on NIOS registration site?
Violation of UNIQUE KEY constraint
Violation of PRIMARY KEY constraint 'PK__student__3213E83FBB0F63EB'. Cannot insert duplicate key in object 'dbo.student'. The duplicate key value is (1).
Violation of PRIMARY KEY constraint 'PK_Section_details'. Cannot insert duplicate key in object 'dbo.Section_details'. The statement has been terminated.
Violation of PRIMARY KEY constraint 'PK_LogIn'. Cannot insert duplicate key in object 'dbo.LogIn'.
Violation of PRIMARY KEY constraint 'PK__brands__5E5A8E277A496106'. Cannot insert duplicate key in object 'production.brands'. The duplicate key value is (12).
violation of primary key constraint pk_T_registration, cannot insert duplicate key in the object dbo.T_registration error
Violation of PRIMARY KEY constraint 'PK_LogIn'. Cannot insert duplicate key in object 'dbo.LogIn'.
How To SHOW mESSage for Unique key Violation of UNIQUE KEY constraint 'IX_Policy_Absent_Policy'. Cannot insert duplicate key in object...
Violation of PRIMARY KEY constraint 'PK_Auto_Part_Details'. Cannot insert duplicate key in object 'dbo.Auto_Part_Details'. The duplicate key value is (1).

Advertise
Privacy
Cookies
Terms of Use
Last Updated 6 Aug 2013
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web01 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900