How can you Join multiple tables in a DataSet C#

Question

I've converted an xml document into a DataSet with DataTables containing relational infomation.

I need to merge the tables into a single table exploiting the relational information is there a way to Do SQL like queries on a Dataset to get a dataTable which can be subsequently used to populate a datagrid?

Answer 1

You probably want to look at the DataRelation class.

I wont repeat all the MSDN docs.

Answer 2

Hi

there is an example: here

I hope that will help you. If not, there is another (more complicated) example: here