title: DataSet Select Where Condition
body: <p>I have a DataSet where I want to be able to have a Select Where Condition based on a search made by the user and bind the data back to the GridView. </p>
  
  <pre><code>DataRow[] result = mainData.Tables[0].Select("Last_Name like '%Knitter%'");
  </code></pre>
  
  <p>How do I take this result store it back into a DataSet and bind it to a GridView or how do I bind the DataRow result to a GridView?</p>
  
  <p>Thanks for your help in advance.</p>
  
  <h2><strong>Update</strong></h2>
  
  <p>Actually I think I got it. All I had to do is:</p>
  
  <pre><code> mainData.Tables[0].Select("Last_Name like '%Knitter%'").CopyToDataTable();
  </code></pre>