Retreiving data from a DataSet

[juhaka]

Hi!

I got (in my software) a large DataSet object via a WebService. The DataSet contains many DataTables, and it is well structured with primary - and foreign keys and relations. It is like a virtual database (I think, this is the main idea of DataSet!).
But how can I retreive data from it? Of course, I can loop tables and rows, but it is very rough way. Can I use any sophisticated method, e.g. like SQL statements?

(I can't do my own sql queries to the database; I have just few web service methods.)

br. Juha Ka

 

[tgreer]

No, you can't run SQL. You manipulate the DataTables. For master/detail relationships, you use the DataRelation Collection. You can also create DataViews, and use those.

I would recommend exploring the DataView. This is a complex subject, and so I don't want to get real specific and perhaps lead you down a path that doesn't fit your application.

Look at DataView, and if it doesn't do what you want, then tell us more about your application and we'll find a better fit.





Thomas D. Greer

http://www.tgreer.com

Providing PostScript & PDF
Training, Development & Consulting

 

[juhaka]

Thanks, Thomas
I will familiarize with DataView, and I will affect you again, if it does not fit to my purpose. ;O)

br. Juha Ka