private void button1_Click_1(object sender, EventArgs e)
{
MySqlConnection con = new MySqlConnection(MyConString);
con.Close();
con.Open();
string m = "INSERT INTO Tools (TCode,TName,Description,
Classification,Model,Capacity,Status,Quantity,
Avaiability,DatePurchased,DateDelivered)
VALUES (@TCode,@TName,@Description,
@Classification,@Model,@Capacity,@Status,@Quantity,
@Avaiability,@DatePurchased,@DateDelivered)";
MySqlCommand cmd = new MySqlCommand(m, con);
cmd.Parameters.Add("@TCode", MySqlDbType.VarChar).Value = txtCode.Text;
cmd.Parameters.Add("@TName", MySqlDbType.VarChar).Value = txtName.Text;
cmd.Parameters.Add("@Description", MySqlDbType.VarChar).Value = txtDesc.Text;
cmd.Parameters.Add("@Classification", MySqlDbType.VarChar).Value = txtClass.Text;
cmd.Parameters.Add("@Model", MySqlDbType.VarChar).Value = txtModel.Text;
cmd.Parameters.Add("@Capacity", MySqlDbType.VarChar).Value = txtCapacity.Text;
cmd.Parameters.Add("@Status", MySqlDbType.VarChar).Value = txtStat.Text;
cmd.Parameters.Add("@Quantity", MySqlDbType.VarChar).Value = txtQuantity.Text;
cmd.Parameters.Add("@Availability", MySqlDbType.VarChar).Value = ttAvail.Text;
cmd.Parameters.Add("@DatePurchased", MySqlDbType.VarChar).Value = txtDP.Text;
cmd.Parameters.Add("@DateDelivered", MySqlDbType.VarChar).Value = txtDD.Text;
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Successful!", "Message");
}
Asked
Active
Viewed 2,093 times
-1
-
1Why are you closing the connection at a freshly created object? – Andre Calil Aug 09 '12 at 03:01
1 Answers
3
Isn't it @Avaiability
instead of @Availability
in here?
cmd.Parameters.Add("@Availability", MySqlDbType.VarChar).Value = ttAvail.Text;
kindly check which one is the correct name of your column: Avaiability
or Availability
.
Thanks.

John Woo
- 258,903
- 69
- 498
- 492