Fire query on DataSet

[Arun Gupta via .NET 247]

DataSet is supposed to be an in-memory database. So is itpossible to fire a query on it. I want to fire a "Select" query(with alises in it) and also a "Transform" (Crosstab) query. Inthe current scenario I am putting things in an Access table butfor performance reasons want to deal with in-memory contents.

Thanks in advance.

 

[Miha Markic [MVP C#]]

DataSet is supposed to be an in-memory database.

No.

So is it possible to fire a query on it. I want to fire a "Select" query
(with alises in it) and also a "Transform" (Crosstab) query. In the current
scenario I am putting things in an Access table but for performance reasons
want to deal with in-memory contents.

You can sort and filter data plus use calculated columns but you can't do
real world sql statements.

 

[Guest]

hi
You can either use DataTable.Select or DataView.FindRows to select rows
from a datatable using a filter expression


regards
Ansil