Query against DataSet

[binodbdrchand]

Hello all. A novice here. Have a DataSet with 7 tables. Want to query against it instead of the Database all the time. Any pointers will be greatly appreciated.

 

[cjard]

any tables that have a primary key had a FindByXXXYYYZZZ method. If this does not suit you, use the datatable.Select() method, where the string passed into the method adopts a similar syntax to DataColumn.Expression Property (System.Data)

rows() = myDataTable.Select("[LastName] LIKE '*smith*' ");


note that databases are programmed to do searching, whereas this is just a nasty hack to be used occasionally in comparison. I you have heavy search work, make the db do it