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
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…
Hi, I am using the Invoke method to add columns from DataTable DT to another DataTable MergedDT.
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…
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…
I need your help. How can we copy a particular column from one data table to another data table?
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.
This topic was automatically closed after 30 days. New replies are no longer allowed.