我试图使用C#中的ASP.NET插入MySQL数据库,但它正在生成以下错误:
您在SQL语法中有一个错误,检查与您的MySQL Server版本相对应的手册,以获取合适的语法,以便使用接近'values('firan name','surname','surname','Mober number','Mober Number',"电子邮件地址","电子邮件地址",'密码'('。我的注册表格中还有一个字段,该字段已确认密码,但我不想将其存储到数据库中。这是我在做的:
String connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
connection = new MySqlConnection(connectionString);
connection.Open();
MessageBox.Show("Successfully connected to database");
String queryString = "insert into signup_table(first_name,surname,mobile_number,email_address,password," +
"values (@F_Name, @S_Name, @M_Number, @E_Address, @Password)";
command = new MySqlCommand(queryString, connection);
command.Parameters.AddWithValue("@F_Name", FirstN_TextBox.Text);
command.Parameters.AddWithValue("@S_Name", SurN_TextBox.Text);
command.Parameters.AddWithValue("@M_Number", MobileN_TextBox.Text);
command.Parameters.AddWithValue("@E_Address", EmailA_TextBox.Text);
command.Parameters.AddWithValue("@Password",Password_TextBox.Text);
command.ExecuteReader();
connection.Close();
预先感谢...
您错过了一个括号。应该以下内容:
String queryString = "insert into signup_table(first_name,surname,mobile_number,email_address,password) " +
"values (@F_Name, @S_Name, @M_Number, @E_Address, @Password)";
您必须在密码列名称之后替换为'(。
尝试为插入查询创建字符串,例如:
String queryString = "insert into
signup_table(first_name,surname,mobile_number,email_address,password) +
values (@F_Name, @S_Name, @M_Number, @E_Address, @Password)";