读书人

C#SQL语句的from字句异常

发布时间: 2013-04-26 16:27:53 作者: rapoo

C#SQL语句的from字句错误
OleDbDataAdapter adapter = new OleDbDataAdapter("select * from check where 电影名称 ='"+varNumber+"'", conn);
[解决办法]
check是关键字吧,加个中括号试试

OleDbDataAdapter adapter = new OleDbDataAdapter("select * from [check] where [电影名称] ='"+varNumber+"'", conn);

[解决办法]

引用:
check是关键字吧,加个中括号试试

OleDbDataAdapter adapter = new OleDbDataAdapter("select * from [check] where [电影名称] ='"+varNumber+"'", conn);
check和系统关键字check重复了

读书人网 >C#

热点推荐