How to search thru DataSet

[anis_b]

I have loaded a whole single table in a DataSet

Now I want to perform search within the DataSet
which has expressions like..

"ProductName LIKE 'c%' AND QuantityPerUnit > 100"

how do i filter the DataSet with such conditions ?

[Cander]

       
        Dim row() As DataRow = objPersistData.persistDS.Tables("Pascode").Select("PASCode Like 'blaah'")

        NAF = row(0).Item("NAF")
        OBAN = row(0).Item("OBAN")

[DevGrp]

Dim dv as New DataView(ds.Tables("myTable");
dv.RowFilter = "ProductName LIKE 'c%' AND QuantityPerUnit > 100"
dataGrid.DataSource = dv