How to join DataTables to create new DataTables (ASP.NET 2.0)?

I want to merge many DataTables together to construct new DataTables. There are several 1-to-many and many-to-many relationships between the DataTables, so I want to be able to create new DataTables by using JOIN concepts from sql queries. Eventually I want to take the data in the new DataTables and update the real database server- much like using DataSets as a cached database system. The thing is  I want to be able to merge, sort and manipulate DataTables even if it's disconnected from the database. Is there a common way to do this?
bemara57Asked:
Who is Participating?
 
DhaestConnect With a Mentor Commented:
A few interesting articles that can help you on your way
Dataset Features in Asp .net 2.0
http://www.codersource.net/published/view/298/dataset_features_in_asp_net.aspx

How can I do a "Join" between two DataTables?
http://objectsharp.com/cs/blogs/datasetfaq/archive/2004/04/18/369.aspx

Joining ADO.Net DataTables
http://home.hot.rr.com/graye/Articles/DataTableJoins.htm
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.