vs2005中inter into 语句出错 在关键字 'user' 附近有语法错误。 说明: 执行当前 Web 请求期间，出现未处

Question

在关键字 'user' 附近有语法错误。
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.SqlClient.SqlException: 在关键字 'user' 附近有语法错误。

源错误:

行 29: string strsql ="insert into user (nechen,pwd,name,sex,age,birthday,guestion,answer,email,cardtype,cardid,phone,tel,qq,address,post) Values ('" + username.Text + "','" + userpwd.Text + "','" + truename.Text + "','" + sex1 + "','" + userage.Text + "','" + userbirthday.Text + "','" + userquestion.Items + "','" + useranser.Text + "','" + useremail.Text + "','" + usercardtype.Items + "','" + usercardid.Text + "','" + userphone.Text + "','" + usertelphone.Text + "','" + userqq.Text + "','" + useraddress.Text + "','" + userpost.Text + "')";
行 30: SqlCommand mycmd = new SqlCommand(strsql, myconn);
行 31: mycmd.ExecuteNonQuery();
行 32: myconn.Close();
行 33: Response.Redirect("Default.aspx");

Default6.aspx.cs 行: 31

源代码如下：
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 Default6 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
string sex1;
if (rbt1.Checked)
{ sex1 = "男"; }
else
{ sex1 = "女"; }

string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["EDucationConnectionString"]);
SqlConnection myconn = new SqlConnection(settings);
myconn.Open();
string strsql ="insert into user (nechen,pwd,name,sex,age,birthday,guestion,answer,email,cardtype,cardid,phone,tel,qq,address,post) Values ('" + username.Text + "','" + userpwd.Text + "','" + truename.Text + "','" + sex1 + "','" + userage.Text + "','" + userbirthday.Text + "','" + userquestion.Items + "','" + useranser.Text + "','" + useremail.Text + "','" + usercardtype.Items + "','" + usercardid.Text + "','" + userphone.Text + "','" + usertelphone.Text + "','" + userqq.Text + "','" + useraddress.Text + "','" + userpost.Text + "')";
SqlCommand mycmd = new SqlCommand(strsql, myconn);
mycmd.ExecuteNonQuery();
myconn.Close();
Response.Redirect("Default.aspx");
}
}

Answer 1

不能直接使用系统关键字“user”,你可以改成“_user”或其他名字试试！

Answer 2

不能直接使用User 应该换为 insert into [user]后面按原来的可以了..
数据库中有user表的时候,SQL语句应该把 user加 []...