this is my code
using (mcon = new MySqlConnection(conString))
{
try
{
string query1 = "INSERT INTO Login_System_DB.Student_tbl(BARCODE,FNAME,LNAME,COURSE,SEX) VALUES(@BAARCODE,@FNAME,@LNAME,@COURSE,@SEX)";
mcmd = new MySqlCommand(query1, mcon);
mcmd.Parameters.Add("@barcode", MySqlDbType.VarChar, 25);
mcmd.Parameters.Add("@fname", MySqlDbType.VarChar, 25);
mcmd.Parameters.Add("@lname", MySqlDbType.VarChar, 25);
mcmd.Parameters.Add("@course", MySqlDbType.VarChar, 25);
mcmd.Parameters.Add("@SEX", MySqlDbType.VarChar, 25);
mcmd.Parameters["@barcode"].Value = txtBARCODE.Text;
mcmd.Parameters["@fname"].Value = txtStudentFNAME.Text;
mcmd.Parameters["@lname"].Value = txtStudentLNAME.Text;
mcmd.Parameters["@course"].Value = txtCOURSE.Text;
mcmd.Parameters["@sex"].Value = (rbStudentMALE.Checked == true) ? "MALE" : "FEMALE";
mcon.Open();
int RowsAffected = mcmd.ExecuteNonQuery();
if(RowsAffected > 0)
{
Console.WriteLine("Student Data: Inserted Successfully");
}
else
{
Console.WriteLine("Student Data: Insertion Failed");
}
mcmd.Dispose();
string query2 = "INSERT INTO Login_System_DB.Guardian_tbl(FNAME,LNAME,RELATIONSHIP,CONTACTNO,SEX) VALUES(@FNAME,@LNAME,@RELATIONSHIP,@CONTACTNO,@SEX)";
mcmd = new MySqlCommand(query2, mcon);
mcmd.Parameters.Add("@FNAME", MySqlDbType.VarChar, 25);
mcmd.Parameters.Add("@LNAME", MySqlDbType.VarChar, 25);
mcmd.Parameters.Add("@RELATIONSHIP", MySqlDbType.VarChar, 25);
mcmd.Parameters.Add("@CONTACTNO", MySqlDbType.VarChar, 25);
mcmd.Parameters.Add("@SEX", MySqlDbType.VarChar, 25);
mcmd.Parameters["@FNAME"].Value = txtGuardianFNAME.Text;
mcmd.Parameters["@LNAME"].Value = txtGuardianLNAME.Text;
mcmd.Parameters["@RELATIONSHIP"].Value = txtRELATIONSHIP.Text;
mcmd.Parameters["@CONTACTNO"].Value = txtCONTACTNO.Text;
mcmd.Parameters["@SEX"].Value = (rbGuardianMALE.Checked == true) ? "TRUE" : "FALSE";
RowsAffected = mcmd.ExecuteNonQuery();
if(RowsAffected > 0)
{
Console.WriteLine("Guardian Data: Inserted successfully");
}
else
{
Console.WriteLine("Guardian Data: Insertion Failed");
}
mcmd.Dispose();
}
catch(Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
mcon.Close();
}
}
What I have tried:
already tried debugging it by adding break points but no luck... the error it returns also provide insufficient information... pls help.... ^_^