Question

I have problem when inserting a date to my database Insert query:

INSERT INTO users (f_name, s_name, t_name,family_name, age, national_id, 
telephone, mobile,  address, job_name, company_code, start_date, end_date)
VALUES (N " + fname + " ,N " + sname + " ,N " + tname + " ,N " + famiy_name + 
        " ,N " + age + " ,N " + national_id + " ,N " + telephone + 
        " ,N " + mobile + " ,N " + address + " ,N " + job_name + " ,N " + 
        company_code + " ," + start_date + "," + end_date + ")";

脚注“N”在条目前插入阿拉伯文

错误信息:

Incorrect syntax near 12 .

虽然文字视器的日期格式是

2010年11月5日

I use VS2010 with theDB sql express 2008

Answer 1

1. 利用参数而不是按类别划分来建立你的询问:

using (SqlCommand myCommand = new SqlCommand(
    "INSERT INTO users (f_name, s_name, ...) VALUES (@f_name, @s_name, ...)")) {

    myCommand.Parameters.AddWithValue("@f_name", f_name);
    myCommand.Parameters.AddWithValue("@s_name", s_name);
    //...

    myConnection.Open();
    myCommand.ExecuteNonQuery())
    //...
}

Answer 2

www.un.org/Depts/DGACM/index_spanish.htm 为什么出现这种情况? 它希望你能用单一报价限定你的日期。

www.un.org/Depts/DGACM/index_spanish.htm 您应当做些什么:使用

友情链接