MySQL & C# MySql.Data.MySqlClient.MySqlException caught in try catch
23:22 23 Jun 2013

I am getting the following error in my C# code when I press the button. It is caught in my try-catch:

A first chance exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll

I am wondering what it could be that is wrong. Any help is appreciated!

Method:

private void addChildBtn_Click(object sender, EventArgs e)
{
    string firstName = firstNameAdd.Text;
    int ageComboIndex = ageComboAdd.SelectedIndex;
    string age = this.ageComboAdd.Items[ageComboIndex].ToString();

    int genderComboIndex = genderComboAdd.SelectedIndex;
    string gender = this.genderComboAdd.Items[genderComboIndex].ToString();

    string address = addressAdd.Text;

    string caregiverOneName = caregiver1NameAdd.Text;
    string caregiverOnePhone = caregiver1PhoneAdd.Text;
    string caregiverTwoName = caregiver2NameAdd.Text;
    string caregiverTwoPhone = caregiver2PhoneAdd.Text;

    server = "localhost";
    port = "3306";
    database = "childeren";
    uid = "root";
    password = "password";

    MySqlConnection connection2 = new MySqlConnection("Server=" + server + ";" + 
        "Port=" + port + ";" + "Database=" + database + ";" + 
        "Uid=" + uid + ";" + "Password=" + password + ";");

    // Perform databse operations
    try
    {
        connection2.Open();
        string query = "INSERT INTO childdatabase (name2, age, gender, " +
            "adress, caregiver1Name, caregiver1Phone, caregiver2Name, " +      
            "caregiver2Phone) VALUES('" + firstName + "','" + age + 
            "','" + gender + "','" + address + "','" + caregiverOneName + 
            "','" + caregiverOnePhone + "','" + caregiverTwoName + 
            "','" + caregiverTwoPhone + "')";
        MySqlCommand cmd = new MySqlCommand(query, connection2);

        cmd.ExecuteNonQuery();
        connection2.Close();
    }

    catch (Exception ex)
    {
        MessageBox.Show("Failed");
        //updateStatus(ex.Message.ToString());
    }

    connection2.Close();
}

MySQL CREATE tables set up:

create database childeren;
use childeren;
CREATE TABLE childDatabase 
(
    id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, 
    name2 VARCHAR(50), 
    age VARCHAR(3), 
    gender VARCHAR(6), 
    adress VARCHAR(50), 
    caregiver1Name VARCHAR(50), 
    caregiver1Phone VARCHAR(10), 
    caregiver2Name VARCHAR(50), 
    caregiver2Phone VARCHAR(10)
);
c# mysql database