title: How do I delete a row from a Microsoft Access table using c#
body: <p>I've tried this code:</p>
  
  <pre><code>string sql = " DELETE FROM HotelCustomers WHERE [Room Number] =" +  textBox1.Text;
  OleDbConnection My_Connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= c:\\Users\\Documents\\HotelCustomersOld.mdb");
  
  My_Connection.Open();
  
  OleDbCommand My_Command = new OleDbCommand(sql, My_Connection);
  My_Command.ExecuteNonQuery();
  </code></pre>
  
  <blockquote>
    <p>Error: Data type mismatch in criteria expression, at the line:
    My_Command.ExecuteNonQuery();</p>
  </blockquote>