How should I best query my dataset from VB.net?

Question

I have a VB.Net data set that contains data from multiple tables. Does anyone have any good suggestions on how to query data out of the dataset. I want to run SQL-like queries on a dataset to extract data that fits a certain "where" statement.

Answer 1

Use the DataTable.Select() method.

Here is some information from the official MSDN documentation.

As said in later posts, Linq is another possibility and will probably give you much more versatility, which you may not need depending upon your own requirements.