MySQL & C# MySql.Data.MySqlClient.MySqlException beim Try-Catch abgefangen ⇐ C#

[Anonymous]

Ich erhalte die folgende Fehlermeldung in meinem C#-Code, wenn ich die Taste drücke. Es ist in meinem Try-Catch gefangen:


Eine Ausnahme der ersten Chance vom Typ „MySql.Data.MySqlClient.MySqlException“ ist in MySql.Data.dll aufgetreten.


Ich frage mich, was falsch sein könnte. Jede Hilfe ist willkommen!

Methode:

Code: Select all

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-Tabellen eingerichtet:

Code: Select all

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)
);