读书人

INSERT INTO 语句的语法异常

发布时间: 2012-01-09 21:05:42 作者: rapoo

INSERT INTO 语句的语法错误
提示INSERT INTO 语句的语法错误
语句如下:
sql2 = "insert into Student ( Stu_ID,PassWord,Name,Sex,Department,Grade,Class ) values ( ' " + userid + " ', ' " + pwd + " ', ' " + uname + " ', ' " + sex + " ', ' " + depart + " ', ' " + grade + " ', ' " + uClass + " ') ";
把Class改成[Class]还是提示这样的错误~
请高手帮忙看看错在哪里~

[解决办法]
sql2 = "insert into [Student] ( [Stu_ID],[PassWord],[Name],[Sex],[Department],[Grade],[Class] ) values ( ' " + userid + " ', ' " + pwd + " ', ' " + uname + " ', ' " + sex + " ', ' " + depart + " ', ' " + grade + " ', ' " + uClass + " ') "

这样试下

读书人网 >asp.net

热点推荐