title: MS Access SQL LIKE query from C#
body: <p>I have this query for Ms Access and im using C# and Ole DB commands. It works on Ms Access but when I'm passing the query from C# using OleDB, nothing happened. Anyway here's my code: </p>
  
  <p>SQL query</p>
  
  <pre><code>SELECT * FROM tblIssue WHERE  id LIKE '*2*' AND dateChecque LIKE '**'AND +
  issueTo LIKE '**' AND byTheName LIKE '**' AND bankName LIKE '**' AND accountNo LIKE '**' +
  AND checqueNo LIKE '**' AND amount LIKE '**' AND being LIKE '**'   AND whoDeleted LIKE '**' +
  AND whyDeleted LIKE '**' AND dateCreated LIKE '**';
  </code></pre>
  
  <p>C# code</p>
  
  <pre><code>try
  {
      DataTable newDt = new DataTable();
      OleDbDataAdapter newSda = new OleDbDataAdapter(sqlQuery , conn);
      newSda.Fill(newDt);
  
      if (newDt.Rows.Count &gt; 0)
      {
          dataGridView1.DataSource = newDt.DefaultView;
          _hasData = true;
      }
      else
      {
          _hasData = false;
      }
  }
  catch (Exception error)
  {
      MessageBox.Show(error.ToString()); conn.Close();
  }
  </code></pre>