I'm getting an error when I insert same data in textbox txtKVNumber. The error is like: An error has occurred, please try again later. Violation of PRIMARY KEY constraint 'PK_khaas'. Cannot insert duplicate key in object 'dbo.khaas'. The statement has been terminated.
What I have tried:
private void btnKSave_Click(object sender, EventArgs e)
{
try
{
if (txtKVNumber.Text == "")
{
string myStringVariable1 = string.Empty;
MessageBox.Show("Vehicle Number is required");
}
else if (cboKVColor.Text == "")
{
string myStringVariable2 = string.Empty;
MessageBox.Show("Select Vehicle Color");
}
else if (cboKVBrand.Text == "")
{
string myStringVariable3 = string.Empty;
MessageBox.Show("Select Vehicle Brand");
}
else if (cboKVType.Text == "")
{
string myStringVariable12 = string.Empty;
MessageBox.Show("Select Vehicle Type");
}
else if (txtKOName.Text == "")
{
string myStringVariable5 = string.Empty;
MessageBox.Show("Owner Name is required");
}
else if (txtKCivilID.Text == "")
{
string myStringVariable7 = string.Empty;
MessageBox.Show("Civil ID is required");
}
else if (txtKTelephone.Text == "")
{
string myStringVariable8 = string.Empty;
MessageBox.Show("Telephone Number is required");
}
else
{
command = new SqlCommand("insert into khaas( VNumber, VColor, VType, VBrand, ExpiryDate, DaysLeft, OName, CivilID, Telephone ) VALUES (@vnumber, @vcolor, @vtype, @vbrand, @expirydate, @daysleft, @ownername, @civilid, @telephone )", con);
con.Open();
command.Parameters.AddWithValue("@vnumber", txtKVNumber.Text);
command.Parameters.AddWithValue("@vcolor", cboKVColor.Text);
command.Parameters.AddWithValue("@vtype", cboKVType.Text);
command.Parameters.AddWithValue("@vbrand", cboKVBrand.Text);
command.Parameters.AddWithValue("@expirydate", dateTimePickerKhaas.Value.ToString("MM/dd/yyyy"));
command.Parameters.AddWithValue("@daysleft", txtKDaysLeft.Text);
command.Parameters.AddWithValue("@ownername", txtKOName.Text);
command.Parameters.AddWithValue("@civilid", txtKCivilID.Text);
command.Parameters.AddWithValue("@telephone", txtKTelephone.Text);
command.ExecuteNonQuery();
con.Close();
MessageBox.Show("Inserted Successfully");
grd_fillKhaas();
txtKVNumber.Text = "";
cboKVColor.Text = "";
cboKVType.Text = "";
cboKVBrand.Text = "";
dateTimePickerKhaas.Value = DateTime.Now;
txtKDaysLeft.Text = "";
txtKOName.Text = "";
txtKCivilID.Text = "";
txtKTelephone.Text = "";
}
}
catch (Exception ex)
{
MessageBox.Show("An error has occurred, please try again later." + ex.Message);
}
finally
{
con.Close();
}
}