Input string format ?

[Abdu moh]

I have this code whenever I run the program  error occurs " input string was not in a correct format" this for ID value which is also the Primary Key in the Database too . please what is the solution to this error


Employee Class:

public bool updateEmployee(int id, string name, string title, string position, DateTime hdate, string country, DateTime bdate, string gender, string phone, string address, byte[] img)
        {
            MySqlCommand command = new MySqlCommand("UPDATE `employee` SET `EmpName`=@n,`Job_Title`=@jt,'Position'=@p,'Hiring_Date'=@hd,'Country'=@c,`Birthdate`=@bd,`Gender`=@gd,`Phone`=@ph,`Address`=@adr,`Photo`=@img WHERE  `EmpId`= @id", connect.getconnection);

            //@id,@fn, @ln, @bd, @gd, @ph, @adr, @img
            command.Parameters.Add("@id", MySqlDbType.Int32).Value = id;
            command.Parameters.Add("@n", MySqlDbType.VarChar).Value = name;
            command.Parameters.Add("@jt", MySqlDbType.VarChar).Value = title;
            command.Parameters.Add("@p", MySqlDbType.VarChar).Value = position;
            command.Parameters.Add("@hd", MySqlDbType.VarChar).Value = hdate;
            command.Parameters.Add("@c", MySqlDbType.VarChar).Value = country;
            command.Parameters.Add("@bd", MySqlDbType.VarChar).Value = bdate;
            command.Parameters.Add("@gd", MySqlDbType.VarChar).Value = gender;
            command.Parameters.Add("@ph", MySqlDbType.VarChar).Value = phone;
            command.Parameters.Add("@adr", MySqlDbType.VarChar).Value = address;
            command.Parameters.Add("@img", MySqlDbType.Blob).Value = img;

            connect.openConnect();
            if (command.ExecuteNonQuery() == 1)
            {
                connect.closeConnect();
                return true;
            }
            else
            {
                connect.closeConnect();
                return false;
            }

        }

Manage Employee Form :

private void button_update_Click(object sender, EventArgs e)
        {
            // update student record
             int id = Convert.ToInt32(textBox_id.Text);
            string name = textBox_EmpName.Text;
            string title = textBoxJob_Title.Text;
            string position = textBoxPosition.Text;
            DateTime hdate = dateTimePicker_hd.Value;
            string country = textBoxCountry.Text;
            DateTime bdate = dateTimePicker_bd.Value;
            string phone = textBox_phone.Text;
            string address = textBox_address.Text;
            string gender = radioButton_male.Checked ? "Male" : "Female";


            //we need to check student age between 10 and 100

            int born_year = dateTimePicker_bd.Value.Year;
            int this_year = DateTime.Now.Year;
            if ((this_year - born_year) < 10 || (this_year - born_year) > 100)
            {
                MessageBox.Show("The employee age must be between 10 and 100", "Invalid Birthdate", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            else if (verify())
            {
                try
                {
                    // to get photo from picture box
                    MemoryStream ms = new MemoryStream();
                    pictureBox_employee.Image.Save(ms, pictureBox_employee.Image.RawFormat);
                    byte[] img = ms.ToArray();
                    if (employee.updateEmployee(id,name, title, position, hdate, country, bdate, gender, phone, address, img))

                    {
                        showTable();
                        MessageBox.Show("Employee data update", "Update Employee", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        button_clear.PerformClick();
                    }
                }
                catch (Exception ex)

                {
                    MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            else
            {
                MessageBox.Show("Empty Field", "Update Employee", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }


        }