'nvarchar'附近的语法不正确。必须声明标量变量“@Conform”。怎么解决这个错误 [英] Incorrect syntax near 'nvarchar'. Must declare the scalar variable "@Conform". how solve tis error

问题描述

SqlCommand cmd = new SqlCommand();
       cmd.Connection = con;
       cmd.CommandType = CommandType.Text;
       cmd.CommandText = "insert into Register values(@Username,@Password,@Conform mail,@Repeat mail,@Date of birth,@Gender,@Mobile,@Address,@Select country,@Select state,@Select city,@Security question,@Captcha image)";
       cmd.Parameters.AddWithValue("@Username",TextBox1.Text.ToString());
       cmd.Parameters.AddWithValue("@Password", TextBox2.Text.ToString());
       cmd.Parameters.AddWithValue("@Conform mail", TextBox3.Text.ToString());
       cmd.Parameters.AddWithValue("@Repeat mail", TextBox4.Text.ToString());
       cmd.Parameters.AddWithValue("@Date of birth", TextBox5.Text.ToString());
       cmd.Parameters.AddWithValue("@Gender", RdoGender.SelectedItem.Text.ToString());
       cmd.Parameters.AddWithValue("@Mobile", TextBox7.Text.ToString());
       cmd.Parameters.AddWithValue("@Address", TextBox6.Text.ToString());
       cmd.Parameters.AddWithValue("@Select country", DropDownList1.Text.ToString());
       cmd.Parameters.AddWithValue("@Select state", DropDownList2.Text.ToString());
       cmd.Parameters.AddWithValue("@Select city", DropDownList3.Text.ToString());
       cmd.Parameters.AddWithValue("@Security question", TextBox9.Text.ToString());
       cmd.Parameters.AddWithValue("@Captcha image", TextBox8.Text.ToString());

       con.Open();
       cmd.ExecuteNonQuery();
       Response.Redirect("default.aspx");

       con.Close();

推荐答案

空间是问题所在。使用单字参数名称，如 @Conformmail （右一个）而不是 @Conform mail （错误的）。其他参数也是如此，例如 @Repeat mail ， @Date of birth 等，

Space is the problem. Use single word parameter names like @Conformmail(right one) instead of @Conform mail(wrong one). Same thing goes for other parameters like @Repeat mail, @Date of birth, etc.,

这篇关于'nvarchar'附近的语法不正确。必须声明标量变量“@Conform”。怎么解决这个错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！