adding two datatables together from xml database.

[cayongrayoo]

I have a database in the form of an xml file which the user supplies the program with, so as the programmer I should not change it. the data I need from this database is in two different tables. I want to display this data in one datagridview. So far it puts the database in a dataset and displays one table in a datagridview. How do I get the two tables I want into one table? Been told to look into dataviews but I don't understand what they mean when theystart talking about sql? I can do SQL but I don't get why I need a connection string when my database is already in a dataset?

Thanks if you can help me

 

[JohnH]

You can use LINQ to XML and write for example a Linq Join query.