title: Need to add where clause to a table adapter
body: <p>I have a dataset setup by using the Visual Studio wizard and in the form is this line of code:</p>
  
  <pre><code>Me.StudentsTableAdapter.Fill(Me.StudentsDataSet.Students)
  </code></pre>
  
  <p>The select statement for the table adapter is:</p>
  
  <pre><code>SELECT ID, Forename, Surname, AddressLine1, AddressLine2, City, State, PostCode, 
         PrimaryPhone, SecondaryPhone, DateOfBirth, email, Grade, GPA, ParentID 
    FROM Students
  </code></pre>
  
  <p>Can you tell me how to add a Where clause using coding on this table adapter?</p>