Can it be true that it is not possible to use SQL queries together with a DataSet? I find it hard to believe.

If it is not possible, is there a way around it? E.g. transforming the data to another type and then perform SQL joins on the transformed data?

Thanks, Jacob.

__________________
Danish audio books for download at http://www.lytenbog.dk (Danske lydbøger til download).

You can populate a dataset from a SQL query. You could populate several related tables in a dataset. Then you can establish relationships between the tables that represent foreign key relationships in the database. Then you can use SQL style elements to define a table's filter and sort. Also, you can use the relationships between the tables to retrieve child rows. But I don't think it's possible to perform pure SQL style queries as a dataset as if it were a database.

-Peter

Alright, thanks.

I have two sources for constructing the DataSet; i.e. a database and possibly altered data in a UI, and therefore I cannot use the SQL approach on the database directly (defining the SQL directly). I have to do join queries on the DataSet, and hoped for work-around, but I see that no shortcuts.

What about XPath? It must be possible to get an XML representation of the DataSet, and then do XPath queries. Can XPath define constructions such as join?

Jacob.

The dataset has a GetXml() method which will return the internal XML representation of the whole dataset. You could suck that into an XmlDocument object and do any XPath queries against it.

I don't often work with complex DataSets but I suspect there must be a way of doing what you need.

-Peter

Thanks Peter, I think I will try that approach. BR, Jacob.

WTF? Why bring this thread up from the ashes with such a lame line?
Mods BURNINATE! :D

Rob
http://cantgrokwontgrok.blogspot.com