sorry, my fault on the only calling the bind line above.
Just add the call to your if condition inside your ok button click after ok_Button.Enabled = false;
So your okButton_Click would look like this:
private void okButton_Click(object sender, EventArgs e)
{
int intInsert = 0;
String connString = (@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Projects\RentalPlus\RentalPlus\KombiDB.mdf;Integrated Security=True;User Instance=True");
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "INSERT INTO KombiStateTbl (NumberPlate, LicenseExpiryDate, ControlDate, "
+ "Documentos, FaróisLanternas, EstepeMacacoChaveDeRoda, Triângulo, Extintor, Acendedor, "
+ "RodasCalota, Retrovisores, Párabrisa, BancosTapetes, Pneus, ParachoqueDianteiro, "
+ "ParachoqueTraseiro, PortaDianteiraDireitaM, PortaDianteiraEsquerdaP, PortaLateral, "
+ "LateralEsquerda, LateralEsquerdaTraseira, LateralDireitaTraseira, ParalamaTraseiroDireito, "
+ "ParalamaTraseiroEsquerdo, Teto, PortaDoPortaMalas, PortaTraseiraDoMotor, Traseira, "
+ "Dianteira, FaróisDianteiros, FaroisTraseiros, CurrentPic, CurrentPicPath) VALUES "
+ "(@Param1,@Param2,@Param3, 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', "
+ "'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', "
+ "'OK', 'OK', 'OK', 'OK', NULL, NULL)";
cmd.Parameters.Add("@Param1", SqlDbType.Char).Value = noPlateTextBox.Text;
cmd.Parameters.Add("@Param2", SqlDbType.Char).Value = licenseDateTimePicker.Text;
cmd.Parameters.Add("@Param3", SqlDbType.Char).Value = controlDateTimePicker.Text;
cmd.Connection = conn;
conn.Open();
intInsert = cmd.ExecuteNonQuery();
conn.Close();
if (intInsert != 0)
{
MessageBox.Show("The data insertion is successful", "Success", MessageBoxButtons.OK,
MessageBoxIcon.Information);
noPlateTextBox.Text = "";
okButton.Enabled = false;
Main_Load.bindComboBox();
}
else
{
MessageBox.Show("The data insertion is failed", "Error", MessageBoxButtons.RetryCancel,
MessageBoxIcon.Error);
}
}