c# - MS-Access 查询语法

Question

我有mysql背景。现在我正在使用 C# 开发 MS-Access。我尝试了以下 sql 查询，但它抛出异常

查询 1:

String strSql = "Select * from Employees orderby EmployeeID desc limit 1;";
OleDbDataAdapter adapter = new OleDbDataAdapter(strSql, conn);
adapter.Fill(dt);

String strSql = "Select * from Employees orderby EmployeeID asc limit 1;";
OleDbDataAdapter adapter = new OleDbDataAdapter(strSql, conn);
adapter.Fill(dt);

常见异常 1:

Additional information: Syntax error in FROM clause.

查询 2:

String strSql = "select * from Employees where EmployeeID = (select min(EmployeeID) from Employees where EmployeeID < '" + Int64.Parse(this.txtBoxID.Text) + "');";
OleDbDataAdapter adapter = new OleDbDataAdapter(strSql, conn);
adapter.Fill(dt);

String strSql = "select * from Employees where EmployeeID = (select min(EmployeeID) from Employees where EmployeeID > '" + Int64.Parse(this.txtBoxID.Text) + "');";
OleDbDataAdapter adapter = new OleDbDataAdapter(strSql, conn);
adapter.Fill(dt);

常见异常 2:

Additional information: Data type mismatch in criteria expression.

我的数据库在下面

Answer 1

为什么不使用查询设计器在 Access 中创建查询，更改为 sql View ，然后将 sql 复制回您的代码中？

此外，我认为您必须拥有 Access 权限-

SELECT TOP 1 * from Employees;

而不是

Select * from Employees limit 1;