读书人

这句SQL话语哪错了

发布时间: 2012-06-23 14:52:43 作者: rapoo

这句SQL语句哪错了?

C# code
Insert into [User] (User,Pass,Jifen,Zhuangtai,QQ,Email,Q,A,Dengji,ZhuceIP,DengluIP,Denglushijian,Zhuceshijian) values('xiaoc','zxczxc','0','0','123','zhuxiaocan461@vip.qq.com','111','222','0','1','1','1','1')


System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。

[解决办法]
Insert into [User] ([User],Pass,Jifen,Zhuangtai,QQ,Email,Q,A,Dengji,ZhuceIP,DengluIP,Denglushijian,Zhuceshijian) values('xiaoc','zxczxc','0','0','123','zhuxiaocan461@vip.qq.com','111','222','0','1','1','1','1')
?



[解决办法]
User是数据库保留的名称,就像C#代码里不能用if做变量名,非得用的话要加上@一样

读书人网 >C#

热点推荐