title: How can I filter the result of sql select query on datagrid view
body: <p>I have a Sql query on my form displaying all records having a duedate of the year 2013 in my tableA filling the datagrid view. And I have also a button and textbox.</p>
  
  <p>What I wanted to do is to filter the result of my sql query on the datagrid view, Is it Possible to have another sql like this:</p>
  
  <p><code>"SELECT caseno, duedate,remarks from (the data on my datagrid view)"</code></p>
  
  <p>this is my datagrid sample:</p>
  
  <pre><code>    caseno      duedate       remarks
      1001        1/12/13       passed
      1002        1/22/13       passed
      1003        1/15/13       failed
      1004        1/20/13       none
      1005        1/06/13       failed
  </code></pre>
  
  <p>when I click the button I want to display on my datagrid all the records having a remarks that i typed on my textbox. anyone can help me? tnx! try to make it simple :)</p>