title: how to select from a table in access with a string variable
body: <p>I have a <code>database</code> in ms-access and wanted to select from it, </p>
  
  <p>I know my question is very simple but I couldn't find the solution for it</p>
  
  <p>this is how I want to select:</p>
  
  <pre><code>public static void SearchRationCreatorName(string RationCreator)
      {
          string StrCon = System.Configuration.ConfigurationManager....
          OleDbConnection Connection = new OleDbConnection(StrCon);
          OleDbDataAdapter DataA = new OleDbDataAdapter
  ("Select * from tRations where tRations.RationCreator= [RationCreator]", Connection);
  
          DataTable Dtable = new DataTable();
          DataA.Fill(Dtable);
  </code></pre>
  
  <p>but instead of selecting one row it select all of records in that table</p>