[Solved] ASP.Net Error: Cannot insert duplicate key in object The statement has been terminated

Question

I have added validtion but its not working propelywhile i have change month and insert value then i have getting mention errorViolation of PRIMARY KEY constraint PKleadlag Cannot insert duplicate key in object dboleadlag The duplicate key value is 1 The statement has been terminatedSome one help to complate my task

dharmendr · Accepted Answer

Hi indradeoYou are trying to insert a duplicate value 1 in dboleadlag table in primary columnA Primary Key is unique throughout the table You cant insert the same value into a primary key column twiceTo avoid the error you can set auto increment for the primary column and then there should never be a problem with duplicating the value the database will take care of that

[Solved] ASP.Net Error: Cannot insert duplicate key in object The statement has been terminated

Violation of PRIMARY KEY constraint 'PK_lead_lag'. Cannot insert duplicate key in object 'dbo.lead_lag'. The duplicate key value is (1). The statement has been terminated.

Company

Explore

Follow us

Contact Us