c# - From 子句 ms Access 中的语法错误

Question

我正在尝试使用以下代码从 Ms access 数据库中查询数据。

string sql = @"INSERT INTO Mre_Pole (ElementID,GlobalID,UpdateState) values (:ElementID,:GlobalID,:UpdateState)";
string commandText2 = @"SELECT TOP 1 * FROM Mre_Pole ORDER BY objectid DESC";
command.CommandText = sql;
command.Parameters.AddWithValue(":ElementID", entityGuid.EntityId);
command.Parameters.AddWithValue(":GlobalID", entityGuid.Guid);
command.Parameters.AddWithValue(":UpdateState", UpdateState.Added);
command.ExecuteNonQuery();
command.Parameters.Clear();
command.CommandText = commandText2;

OleDbDataAdapter dataAdapter = new OleDbDataAdapter(command);
DataSet ds = new DataSet();
dataAdapter.Fill(ds);

但它抛出异常 dataAdapter.Fill(ds);

Syntax Error in From clause

谁能帮我解决这个问题。

Answer 1

尝试

改变

OleDbDataAdapter dataAdapter = new OleDbDataAdapter(command);
DataSet ds = new DataSet();
dataAdapter.Fill(ds);

到

 OleDbDataAdapter dataAdapter = new OleDbDataAdapter(commandText2,"your oledbconnection");
    DataSet ds = new DataSet();
        dataAdapter.Fill(ds);