title: How I can search rows in a datatable with a searchstring?
body: <p>I want to search rows in my <code>DataTable</code>.</p>
  
  <p>I've tried this:</p>
  
  <pre><code> protected void imggastsuche_Click(object sender, EventArgs e) 
          {
              string searchstring = txtgastsuche.Text;
  
              DataTable tb = DataBaseManager.GetDataTable(mysqlconnectionstring);
  
              DataRow[] foundRows = tb.Select("FIRSTNAME,LASTNAME,NAME,COMPANY,TIMEFROM,TIMETO,CREATOR Like '%" + searchstring + "%'");
  
              tb = foundRows.CopyToDataTable();
  
              this.ListView.DataSource = tb;
              this.ListView.DataBind();
  
          }
  </code></pre>
  
  <p>But I have an error in my string.</p>
  
  <p>What can I do if I want to search these columns?</p>