Dear all,

I created a winform that display an item master in a DataGridView, bound with a DataView. Let's just say it has columns/fields
  • item_id
  • item_name
  • item_description

I wanted to make a single text box that will be searched in all fields. So if any field in a row contains searched item, it will be displayed.
My current idea is to create a DataView with RowFilter contains all rows such

Code:
myDataView.RowFilter = "item_id LIKE '%" & Me.txtSearch.Text & "%' OR " & _
                       "item_name LIKE '%" & Me.txtSearch.Text & "%' OR " & _
                       "item_desc LIKE '%" & Me.txtSearch.Text & "%'"
Is there any smarter way to do this?
I'm afraid this code will cause a big slowdown for a larger dataset.....

Thanks in advanced.

Yoachan