Search for a string in an mdb column

[nikel]

Hi, my app is using an mdb database and one of my form is holding a dataset, a databindingsource and a tableadapter. I want to search if the column "product_name" has a cell with some value (for example: LENOVO Z5070 İ5-4210U 8G 1TB+8G SSHD 15.6")

Is there a simple way to do this?

[Leary222]

look into DataSet.Filter

[nikel]

Thanks for the reply. I searched for "DataSet.Filter" but couldn't find what I was looking for. Could you give me example code?

[techgnome]

On the DataTable, there is a DefaultView property, which contains a RowFilter property that you can set similar to a SQL WHERE clause.
http://stackoverflow.com/questions/5...ing-datasource
There is also this which takes a slightly longer route by skipping the devault view and creating a new one and assigning it to the DGV each time.
http://vb.net-informations.com/datag...dview_sort.htm

-tg