Merge two tables

[xoxoxoxoxoxox]

I want two merge two tables A & B. Table-A contains column A, B, C and Table-B contains column D, E, F. I want the result table to contain columns from both tables i.e., A,B,C,D,E,F. Is there a way to accomplish this in C#? I'll greatly appreciate any response.

[Christian Graus]

How do rows in the two columns map to each other, so that such a join makes sense ? Where are the tables coming from ? The most sensible thing would be to write SQL to return a table that merges the two tables together, assuming there's a way of doing that logically.

Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

[J 0]

I assume that you're saying you want to merge 2 System.Data.DataTable objects into one. If thats not the case forgive me... If this data is coming from 2 separate, but related tables in your database, you can add them to a DataSet, and set up a DataRelation between the 2 tables. This doesn't merge the 2 tables into 1, but it will allow you to retrieve the data for a particular DataRow in DataTable1, as well as the DataRows from DataTable2 that are related to it. You can get the related row information by calling dataRow.GetChildRows(), dataRow.GetParentRow(), or dataRow.GetParentRows() Hope that helps...

[xoxoxoxoxoxox]

Thank you very much for your response. Yes, i want to merge 2 DataTable objects into one. I'll try the method you suggested. Thanks again.