title: Filter Search in Datagridview using textbox
body: <p>I have a <code>searchbox</code> as shown in the image below. I want that when i type a letter or a number, the data <code>gridview</code> will display the data that matches to what I've inputted in the <code>searchbox</code>. I have already a code for that but it is only for one column and it only works at first but when I add other data, it is not working at all. Can you please suggest a better code for that? Thank you! :)</p>
  
  <p>Btw, here's my code for the filter:</p>
  
  <pre><code>Private Sub txtSearch_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtSearch.TextChanged
              EmployeeProfileBindingSource.Filter = String.Format("[Employee_Lname] Like '{0}%'",
    Me.txtSearch.Text.Trim())
  
          End Sub
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/1t7m1.png" alt="enter image description here"></p>
  
  <p><a href="https://i.stack.imgur.com/bUuXT.png" rel="nofollow noreferrer">Image here</a></p>