Filter each cell in dgv

[t3cho]

I'm inputting it directly on DGV by using SQL Query. After i get the data by using sql query data was in dataset. After i use dgv source to get the data from dataset to dgv.

But the problem would be when i enter two values in textbox1.text. In that case i need result which contains in two columns those values.

ex: Bran Prod

It should give me result where it contains Name & location or any other two columns.