Exception Violation of PRIMARY KEY constraint 'PK_tbl_LineSt

Yogesh Vedpathak

Violation of PRIMARY KEY constraint 'PK_tbl_LineStatus1'. Cannot insert duplicate key in object 'dbo.tbl_LineStatus1'.

The statement has been terminated.

This is my Piece of code

using (sqlTrans = sqlCon.BeginTransaction("Trans"))
{
try
{
string query = "Insert into tbl_LineStatus1(TransID,Date,LineID,UserID) Values('" + TransID + "','" + DateTime.Now.ToString("dd/MM/yyyy") + "','" + ddl_linenumber.SelectedItem.Value.ToString() + "','" + username.ToString() + "')";
sqlCmd = new SqlCommand(query, sqlCon);
sqlCmd.Transaction = sqlTrans;
sqlCmd.ExecuteNonQuery();
}
catch(Exception ex)
{
}

3 Replies

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

Shweta Lodha8y ago
Accepted answer
Hi Yogesh,

As error clearly says, the data you are trying to insert in table is already present with respect to Primary key. If TransID is your primary key, then please cross check the value you are inserting for this field.
Yogesh Vedpathak8y ago
Thanks Shweta
Rafnas T P8y ago
hi,

you are getting primary key violation error because you are trying insert same LineID (your primary key) again, check your primary id column, this id should be unique, it should not allow duplicate values