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 ?
Printable View
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 ?
Code:
Dim row() As DataRow = objPersistData.persistDS.Tables("Pascode").Select("PASCode Like 'blaah'")
NAF = row(0).Item("NAF")
OBAN = row(0).Item("OBAN")
VB Code:
Dim dv as New DataView(ds.Tables("myTable"); dv.RowFilter = "ProductName LIKE 'c%' AND QuantityPerUnit > 100" dataGrid.DataSource = dv