title: Returning no results with a query from a WinForm to an Access data base
body: <p>My form has a combo box, a button and a text box. I want to select an item from the combo box, click the button and have it populate the text box with the queried item based on what was in the combo box.</p>
  <p>Currently this is returning zero results even though there is data there. Could someone please eyeball this for me?  I am a bit lost and google hasn't really helped.</p>
  <pre><code>private void button1_Click_1(object sender, EventArgs e)
  {
      OleDbConnection con = new OleDbConnection(@&quot;Provider=Microsoft.ACE.OLEDB.12.0;Data Source = C:\Users\Me\source\repos\Test\Test\Data.accdb; Persist Security Info=True;&quot;);
  
      OleDbCommand cmd = new OleDbCommand (&quot;SELECT ('ECP Rev') AS revision FROM ECP WHERE 'ECP Number' like '&quot; + comboBox1.SelectedItem.ToString() + &quot;' &quot; ,con);
      cmd.Connection = con;
  
      con.Open();
  
      OleDbDataReader read = cmd.ExecuteReader();
  
      while (read.Read())
      {
          textBox1.Text = read[&quot;revision&quot;].ToString();
      }
  }            
  </code></pre>