I have a Windows Form which contains 3 text boxes. The text boxs are bound to a dataset containing Column1, Column2 and Column3. I have added a 4th text box named txtSearchBox. Using the code below I can filter the dataset by any single column. What I would like to do is create a Search All feature. Somthing like: .Filter = "Column1 OR Column2 OR Column3 LIKE '%" & txtSearchBox.Text & "%'" , of course this doesn't work. Any ideas on how to search/filter a dataset on all columns?
Private Sub txtSearchBox_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtSearchBox.TextChanged
.Filter = "Column1 LIKE '%" & txtSearchBox.Text & "%'"