title: Query a datatable where text contains
body: <p>Building on this question: <a href="https://stackoverflow.com/questions/5726636/how-to-run-query-on-dataset">how to run query on dataset?</a></p>
  
  <p>I'm trying to query a datatable from my dataset where the text contains a string, similar to the <code>String.Contains</code> method or the sql LIKE operator.</p>
  
  <p>Here's what I've tried so far:</p>
  
  <pre><code>    private void textBox1_TextChanged(object sender, EventArgs e)
      {
          DataTable tbl = globals.UserDataSet.Tables[0];
          DataRow[] tempDataRows = tbl.Select("USER_ID Like " + textBox1.Text + " OR THE_NAME Like " + textBox1.Text);
      }
  </code></pre>
  
  <p>This gives a System.Data.SyntaxError error.  </p>
  
  <p>Is it possible to query a datatable for text containing a substring?  Is there a better way of doing this?</p>