title: Data type mismatch C#
body: <p>Hi I'm having an issue when selecting data in my MS Access database. It gives me this error. My MS Access column is on short text because some ID are a mix of string and numbers. I just don't understand that this value  = 1007948 is error where I have the value 1007949 which is working correctly. </p>
  
  <blockquote>
    <p>ADO.NET:Execute Reader "SELECT * FROM ReqValidation WHERE ReqNo = 1007948"
        The command text "SELECT * FROM ReqValidation WHERE ReqNo = 1007948" was executed on connection "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=reqRawData.accdb;
        Persist Security Info=False;", building an OleDbDataReader using one of the CommandBehavior values.
        Time: 8/1/2017 3:54:46 PM
        Thread:[15912]</p>
  </blockquote>
  
  <p>My code is like this:</p>
  
  <pre><code>public int dbCommandSelectData2(string reqID)
  {
      using (OleDbConnection conn = new OleDbConnection(connectionStringData))
      {
          //using (OleDbDataAdapter adapter = new OleDbDataAdapter(sqlCommandText, conn))
          //{
          //    DataSet ds = new DataSet();
          //    adapter.Fill(ds);
          //    return ds;
          //}
  
          OleDbCommand cmd = conn.CreateCommand();
          cmd.CommandText = "SELECT * FROM ReqValidation WHERE ReqNo = " + reqID + "";
          conn.Open();
          OleDbDataReader rdr = cmd.ExecuteReader();
          //Check records are exixts or not
          if (rdr.HasRows == true)
          {
              return 1;
          }
          else
          {
              return 0;
          }  
      }
  }
  </code></pre>