命令执行MYSQL期间遇到致命错误 [英] Fatal error encountered during command execution MYSQL

问题描述

这是我的代码

this is my code

using (mcon = new MySqlConnection(conString))
            {
                try
                {
                    //insert student data into database
                    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);

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

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

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

                    //VALUES
                    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.... ^_^

推荐答案

找到我的解决方案，BAARCODE> BARCODE感谢我...

Found my solution, BAARCODE > BARCODE thanks to me...

这篇关于命令执行MYSQL期间遇到致命错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！