Query on a DataSet without a "real" DB

[Seb Schöps]

Hi all,

I have a DataSet with only one table. I have created this DataSet on runtime
out of an usual array, so there is no Access or any other DB behind it. I
can't figure out how to query the DataSet without a connection. Every method
that I could use wants to have a connection.
How can I query my DataSet, e.g. with "SELECT Sum(Price) FROM Articles
GROUPED BY Category" and display the results - that can't be too hard, but I
can't figure it out.

Thanks for any help!

Regards Seb

 

[William Ryan eMVP]

you can use the .Compute method of your datatable to accomplish this. You
can use Select and Find as well, in addition to using a DataView's
rowfilter. If you check out this link
http://www.knowdotnet.com/williamryan.html
I have a few articles on Efficiently Using ADO.NET vx which discusses
filtering in depth.

HTH,

Bill

www.devbuzz.com
www.knowdotnet.com