新手请教：emp.ExecuteNonQuery();提示‘；’附近有语法错误。

Question

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;public partial class admin_JobsEdit : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string R_post = TextBox1.Text;
        string R_place = TextBox2.Text;
        string R_number = TextBox3.Text;
        string R_wage = DropDownList1.Text;
        string R_stime = TextBox5.Text;
        string R_jtime = TextBox6.Text;
        string R_unit = TextBox7.Text;
        string R_person = TextBox8.Text;
        string R_photo = TextBox9.Text;
        string R_address = TextBox10.Text;
        string R_code = TextBox11.Text;
        string R_email = TextBox12.Text;
        string R_duty = TextBox13.Text;
        string R_requirement = TextBox14.Text;        string myconnstr = ConfigurationManager.ConnectionStrings["DBConnStr"].ConnectionString;
        SqlConnection conn = new SqlConnection(myconnstr);
        string SQLem = "insert into [recruitment] values(@R_post,@R_place,@R_number,@R_wage,@R_stime,@R_jtime,@R_unit,@R_person,@R_photo,@R_address,@R_code;@R_email;@R_duty;@R_requirement)";
        SqlCommand emp = new SqlCommand(SQLem, conn);
        conn.Open();
        
        SqlParameter paranam2 = new SqlParameter("@R_post", R_post);
        SqlParameter paranam3 = new SqlParameter("@R_place", R_place);
        SqlParameter paranam4 = new SqlParameter("@R_number", R_number);
        SqlParameter paranam5 = new SqlParameter("@R_wage", R_wage);
        SqlParameter paranam6 = new SqlParameter("@R_stime", R_stime);
        SqlParameter paranam7 = new SqlParameter("@R_jtime", R_jtime);
        SqlParameter paranam8 = new SqlParameter("@R_unit", R_unit);
        SqlParameter paranam9 = new SqlParameter("@R_person", R_person);
        SqlParameter paranam10 = new SqlParameter("@R_photo", R_photo);
        SqlParameter paranam11 = new SqlParameter("@R_address", R_address);
        SqlParameter paranam12 = new SqlParameter("@R_code", R_code);
        SqlParameter paranam13 = new SqlParameter("@R_email", R_email);
        SqlParameter paranam14 = new SqlParameter("R_duty", R_duty);
        SqlParameter paranam15 = new SqlParameter("R_requirement", R_requirement);
        
        emp.Parameters.Add(paranam2);
        emp.Parameters.Add(paranam3);
        emp.Parameters.Add(paranam4);
        emp.Parameters.Add(paranam5);
        emp.Parameters.Add(paranam6);
        emp.Parameters.Add(paranam7);
        emp.Parameters.Add(paranam8);
        emp.Parameters.Add(paranam9);
        emp.Parameters.Add(paranam10);
        emp.Parameters.Add(paranam11);
        emp.Parameters.Add(paranam12);
        emp.Parameters.Add(paranam13);
        emp.Parameters.Add(paranam14);
        emp.Parameters.Add(paranam15);
        emp.ExecuteNonQuery();
        conn.Close();
        Response.Write("<script language=javascript>alert( '添加成功！');window.location.href='JobsEdit.aspx';</script> ");
    }
  
}

Answer 1

string SQLem = "insert into [recruitment] values(@R_post,@R_place,@R_number,@R_wage,@R_stime,@R_jtime,@R_unit,@R_person,@R_photo,@R_address,@R_code;@R_email;@R_duty;@R_requirement)";
改成：
string SQLem = "insert into [recruitment] values(@R_post,@R_place,@R_number,@R_wage,@R_stime,@R_jtime,@R_unit,@R_person,@R_photo,@R_address,@R_code;@R_email,@R_duty,@R_requirement)";
中间不应该有“;”，而是“,”。

Answer 2

原来错误隐藏了啊@R_address,@R_code;@R_email;@R_duty;@R_requirement；改为,

Answer 3

string SQLem = "insert into [recruitment] values(@R_post,@R_place,@R_number,@R_wage,@R_stime,@R_jtime,@R_unit,@R_person,@R_photo,@R_address,@R_code;@R_email;@R_duty;@R_requirement)";
  SqlCommand emp = new SqlCommand(SQLem, conn);
==================》
string SQLem = "insert into [recruitment] values(@R_post,@R_place,@R_number,@R_wage,@R_stime,@R_jtime,@R_unit,@R_person,@R_photo,@R_address,@R_code;@R_email;@R_duty,@R_requirement)";
  SqlCommand emp = new SqlCommand(SQLem, conn);
错误都提示这么明显了啊，将红色的分号改为逗号就OK了。

Answer 4

郁闷。现在改过来了。上面提示说插入错误：列名或所提供值的数目与表定义不匹配。
表的数据类型都是nvarchar(50)。