title: vb.net datagridview with dataset as datasource
body: <p>my question is, is there a way to filter records in the dataset and use that records to fill in the datagridview? for example, a datatable (with 3 columns: <code>ID</code>, <code>StudentName</code>, <code>Gender</code>) is filled with list of students. i have two datagrids in the form namely <code>DatagridView1</code> and <code>Datagridview2</code>. <code>DatagridView1</code> is where the the list of student where <code>Gender</code> is equal to <code>M</code> and <code>DatagridView2</code> is where the the list of student where <code>Gender</code> is equal to <code>F</code>.</p>
  
  <p>in my current solution, i am using a loop.</p>
  
  <pre><code>For each iStud as datarow in iDataset.Tables(0).Rows
        IF iStud.Item("Gender").ToString = "M" Then
              'add this record to DatagridView1
        Else
              'add this record to DatagridView2
        End If
  Next
  </code></pre>
  
  <p>is there a way without using a loop?</p>