When i try to execute the following code, i get an error message saying data type mismatch in criteria expression. I am using MS Access database
What I have tried:
Here's the code
private void btnSave_Click(object sender, EventArgs e)
{
try
{
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "insert into master (MOW,GK,CLASS,MAKE,MODEL,YOP,MNTH,PRICE,ENGINE_NUMBER,CHASSIS_NUMBER,CC,HP,LOCATION,LOGBOOK,MERCHANT,REPLACED_ENGINE_NUMBER,REMARKS,COUNTY) values('" + txtMOW.Text + "','" + txtGK.Text + "','" + txtCLASS.Text + "','" + txtMAKE.Text + "','" + txtMODEL.Text+ "','" + txtYOP.Text + "','" + txtMNTH.Text + "','" + txtPRICE.Text + "','" + txtENGINENUMBER.Text + "','" + txtCHASSISNUMBER.Text + "','" + txtCC.Text + "','" + txtHP.Text + "','" + txtLOCATION.Text + "','" + txtLOGBOOK.Text + "','" + txtMERCHANT.Text + "','" + txtRENGINENUMBER.Text + "','" + txtREMARKS.Text + "','" + txtCOUNTY.Text + "')";
cmd.ExecuteNonQuery();
MessageBox.Show("Data Saved !!!!");
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message);
}
}