title: Binding source filtering
body: <p>Hope you can help me with this.</p>
  
  <p>I'd like to filter my <code>datagridview</code> by using a certain keyword like a name for example. 
  I used a data set then bind it to a data source then to my <code>datagridview</code> for viewing. </p>
  
  <p>When I used the <code>bindingsource.filter</code> I can't get any result. </p>
  
  <p>Here is my code:</p>
  
  <pre><code>    Dim ds As New DataSet
      Dim bs As New BindingSource
  
      Dim sql As String = "SELECT TOP 10 * FROM dbo.DimCustomer"
      Dim connection As New SqlConnection(sqlconnectionstring)
      Dim dataadapter As New SqlDataAdapter(sql, connection)
  
  
  
      connection.Open()
      ds.Clear()
      dataadapter.Fill(ds, "Customer")
      connection.Close()
  
  
      bs.DataSource = ds
  
      dgv1.DataSource = bs
      dgv1.DataMember = "Customer"
      bs.Filter = "FirstName = 'Jon'"
  </code></pre>