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.
Vb.net – How should I best query the dataset from VB.net
datasetvb.net
Best Answer
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.