OleDbCommand，在哪里

Question

有一个访问表(CustomersTable)和两个字段(CustomerID，CustomerName) .field#1是数字，field#2是文本：

command.CommandText = "SELECT CompanyName FROM CustomersTable WHERE CompanyName 'Zap'";
command.ExecuteReader();

结果在查询表达式'CompanyName‘Zap’中出现错误(缺少运算符)。

command.CommandText = "SELECT CompanyName FROM CustomersTable WHERE CompanyName VALUES(?)";
command.Parameters.Add("@p1", OleDbType.VarChar).Value = "Zap";
command.ExecuteReader();

结果在查询表达式'CompanyName值(？)中出现错误(缺少运算符)。

我怀疑ExecuteReader()可能不正确。

Answer 1

你错过了=标志。

command.CommandText = "SELECT CompanyName FROM CustomersTable WHERE CompanyName =  @p1";