Copy column(eg: ID) data from DT1 table and paste data on the same column(ID) on dt2

[Deepika (Deepika anipini)]

i have two data tablesDT1 and DT2 and comparing the column header from DT1 to DT2 if header match i need to copy the column data from DT1 and to be paste in DT2 on matched column … can some one suggest any way or using LINQ query

[postwick (Paul Ostwick)]

Why did you post this on the News and Job Board? Put it in Help/Studio.

Anyway, searching the forum before posting a question that has already been answered…

Copy columns from one data table to another, Column already belongs to another DataTable

Hi, I am using the Invoke method to add columns from DataTable DT to another DataTable MergedDT. TargetType: (null) TargetObject: MergedDT.Columns MethodName: Add Parameters: In, DataColumn, DT.Columns(count) In the first iteration where the MergedDT is supposed to be blank, I still get error Column already belongs to another DataTable. I referred to this thread Column 'XXXX' already belongs to another DataTable but it appears I am already doing as the thread suggested. How do I fix this…

Copy data from datacolumn in a new DataTable

I need to copy the information from one column in a datatable to a specific column in another datatable I’m working with excel files that are not standarized and the column names can be different, what I’m doing is using an aditional file with the possible column names that I need to look for and the column name that I need to consolidate the data(lets call it MappingColumns File) where ‘Column Type’ is the column name that I need for my consolidated datatable and ‘Column Name’ is the possible n…

Copying columns between Data Tables

Hi Friends, I need your help. How can we copy a particular column from one data table to another data table? For Example: Let’s assume that we have 2 data tables with names DT1 and DT2. I have to copy a column with the name say “Location” from DT1 to the column by the name “Area” in DT2. Can anyone help me with the same. regards, Ananthu