[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1260
  • Last Modified:

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?
0
bemara57
Asked:
bemara57
1 Solution
 
DhaestCommented:
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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now