C#SQL语句的from字句异常

2013-04-26

C#SQL语句的from字句错误OleDbDataAdapter adapter new OleDbDataAdapter(select * from check where电

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重复了