ASp.NET 连ACCESS数据库 System.Data.OleDb.OleDbException: FROM 子句语法错误。

显示全部楼层 · 2011-2-11 15:35:26

string sqlstr = " select * from 电影类型 select b.MovieTypeID,b.电影名称,a.MovieTypeName,"

+ "b.电影评分,b.观看电影时间,b.观看的方式 from 电影类型 as a inner join 电影汇总 as b on a.MovieTypeID=b.MovieTypeID";

OleDbConnection Con = new OleDbConnection(ConStr);

OleDbDataAdapter Dap = new OleDbDataAdapter(sqlstr, Con);

DataSet myds = new DataSet();

Dap.Fill(myds);
程序运行出错:
System.Data.OleDb.OleDbException: FROM 子句语法错误。

千问 · 2011-2-11 15:35:26

string sqlstr = " select b.MovieTypeID,b.电影名称,a.MovieTypeName,"
+ "b.电影评分,b.观看电影时间,b.观看的方式 from 电影类型 as a inner join 电影汇总 as b on a.MovieTypeID=b.MovieTypeID";