使用OleDB插入记录访问MDB

Question

为什么会发生这种情况？ ：-S这个时间短而简单。哦，我正在连接到一个MDB文件（2007 Access）。

代码：

public bool insertRecord(int SR_Number, string Serial_Number, string Model_Number, bool Chargeable, bool Priority, bool Rollback) 
    { 
     string cmdStr = "INSERT INTO Recovery_CD_Orders ([SR_Number], [Serial_Number], [Model_Number], [Chargeable], [Priority], [Agent_placing_order], [Rollback_reqd]) Values (@SR_Number, @Serial_Number, @Model_Number, @Chargeable, @Priority, @Agent_Placing_Order, @Rollback)"; 

     OleDbCommand cmd = new OleDbCommand(cmdStr, thisCon); 

     cmd.Parameters.AddWithValue("SR_Number", SR_Number); 
     cmd.Parameters.AddWithValue("Serial_Number", Serial_Number); 
     cmd.Parameters.AddWithValue("Model_Number", Model_Number); 
     cmd.Parameters.AddWithValue("Agent_Placing_Order", Environment.UserName); 
     cmd.Parameters.AddWithValue("Chargeable", Chargeable); 
     cmd.Parameters.AddWithValue("Priority", Priority); 
     cmd.Parameters.AddWithValue("Rollback", Rollback); 

     cmd.Connection.Open(); 
     cmd.ExecuteNonQuery(); 
     cmd.Connection.Close(); 
     cmd.Dispose(); 
     return true; 
    } 

错误：

Data type mismatch in criteria expression. 

表布局：

SR_Number: Number 
Serial_Number: Text 
Model_Number: Text 
Agent_Placing_Order: Text 
Chargeable: Yes/No 
Priority: Yes/No 
Rollback: Yes/No 

Answer 1

很难从什么是问题的提出告诉。我怀疑这个问题与AddWithValue类型推断有关。你最好的选择是明确地声明旧式时尚的类型，因为这将告诉访问使用什么。