title: Filtering dataset with condition
body: <p>I am using asp.net 2.0 and c#.</p>
  
  <p>I have a dataset, which is getting the employee info. Now I want to filter the gridview based on a name that the user has put in the search textbox. </p>
  
  <p>I am doing this:</p>
  
  <pre><code>DataSet ds = new DataSet("EmployeeInformation");
  //........ loading DataSet ds with emploee info
  string strExpr;
  strExpr = "Name LIKE %" + txtSearchEmployee.Text.Trim() + "%";
  ds.Tables[0].Select(strExpr);
  </code></pre>
  
  <p>I am getting an error in the last step, that the operator is missing.</p>
  
  <p>Please guide me how can I achieve this. Thanks in advance.</p>