Fire query on DataSet

  • Thread starter Thread starter Arun Gupta via .NET 247
  • Start date Start date
A

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.
 
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.
 
hi
You can either use DataTable.Select or DataView.FindRows to select rows
from a datatable using a filter expression


regards
Ansil
 
Back
Top