How to combine two datatables into single datatable

[K V Sekhar]

Hi all, I am trying to combine two datatables into single datatable... First table contains 3 columns[e.g: 'col1','col2','col3'] Second table contains 2 columns[e.g: 'col4','col5'] Both tables have the same no.of records[rows], but different columns. How to combine them into single table? I need DataTable with columns ['col1','col2','col3','col4','col5']. I am inserting through looping the both the tables and adding values into third table. I tried the Merge (DataTable.Merge()), but it is adding the records to bottom of first one, but i need it should be added to the side[as columns] to first table' Is there any other way? please suggest me. Thanks in advance.

[PIEBALDconsult]

sekhar.k wrote:

I am inserting through looping the both the tables and adding values into third table.

That should work. But a better technique is to use a join in your SQL query to start with.

[Lost User]

Is there a common key column between these two tables?

[K V Sekhar]

Thanks for your response. There is no common key or relation ship between them. Both queries are from different tables.

[Lost User]

Then joining them may not make any meaning since the order of rows returned by SQL Server is not guaranteed. If you still want to proceed, add an IDENTITY column to both tables and use those columns to join the tables.