Exception Violation of PRIMARY KEY constraint 'PK_tbl_LineSt

Question

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)
{
}