Question

ASP.NET '，' 附近有语法错误。 字符串 '' 后的引号不完整。

SqlConnection Con = new SqlConnection("server=.\\sql2005;database=网上书店;integrated security=sspi");
//Con.ConnectionString = "server=.;databease=网上书店;integrated security=sspi";
SqlCommand Com = new SqlCommand();
Com.Connection = Con;
Com.CommandText = "insert into zhuce(用户名，密码，姓名，性别，出生日期，联系地址，邮政编码，联系电话，手机，身份证号）"
+ "values('" + this.txt_User_Name.Text + "','" + this.txt_User_Pwd.Text + "','" + this.txt_Ral_Name + "',"
+ "'" + this.DDL_Sex.SelectedItem.Text + "','" + this.DDL_Year.SelectedItem.Text + "-" + this.DDL_Month.SelectedItem.Text+ "-" +this.DDL_Day. SelectedItem.Text + "',"
+ "'" + this.txt_Address.Text + "','" + this.txt_Postalcode.Text + "','" + this.txt_Tel.Text + "',"
+ "'" + this.txt_Mobile.Text+"','" + this.txt_ID_Card.Text + "')";

Con.Open();
Com.ExecuteNonQuery();
this.Labinfo.Text = "恭喜您注册成功！";
Con.Close();

Answer 1

Com.CommandText = "insert into zhuce(用户名，密码，姓名，性别，出生日期，联系地址，邮政编码，联系电话，手机，身份证号）"

这里面的逗号不能用中文的，要用英文的。

追问

修改过后的

追答

你最好把 COMMANDtEXT 的那个字符串感冒 。。你先保存到字符串，再输出来，就容易 看到错误所在了。

追问

不明白。。。刚学的这个。写明白点儿谢谢，刚接触这个。

追答

给页面输出一个字符串会吧。
string str = "insert into zhuce(用户名，密码，姓名，性别，出生日期，联系地址，邮政编码，联系电话，手机，身份证号）"
+ "values('" + this.txt_User_Name.Text + "','" + this.txt_User_Pwd.Text + "','" + this.txt_Ral_Name + "',"
+ "'" + this.DDL_Sex.SelectedItem.Text + "','" + this.DDL_Year.SelectedItem.Text + "-" + this.DDL_Month.SelectedItem.Text+ "-" +this.DDL_Day. SelectedItem.Text + "',"
+ "'" + this.txt_Address.Text + "','" + this.txt_Postalcode.Text + "','" + this.txt_Tel.Text + "',"
+ "'" + this.txt_Mobile.Text+"','" + this.txt_ID_Card.Text + "')";

content.Response.Write(str); // 不知道你那边是不是这样输出。

加在你的 CON.OPEN 前面