How do I merge 2 data table irrespective of column datatype in C# code

Question

0.00/5 (No votes)

See more:

I have 2 data tables with same column names (Datatable data is from csv files). I use 'Datatable.Merge' option, but since one of the table's particular column's Datatype is not matched with the other table's that column, it is throwing error.

How do I merge 2 Data table irrespective of column datatype in C# code

What I have tried:

1. datatable1.Merge(datatable2);
2. datatable1.Merge(datatable2,false,MissingSchemaAction.Add);

Also tried:-

foreach (var row in dattable2.Rows)
{
datatable1.Rows.Add(row);
}

Posted 20-Mar-20 1:39am

vivektp

Updated 22-Mar-20 20:52pm

v2

Add a Solution

Comments

ZurdoDev 20-Mar-20 8:19am

Write code to loop through and set the particular columns' values.

ZurdoDev 20-Mar-20 8:19am

Or, do it in the database directly. That's a better option if you can.

Maciej Los 20-Mar-20 9:13am

Could you share your datatables structure and sample data?
Why do you need to merge data?

vivektp 23-Mar-20 3:23am

Thanks for your reply..
My Data tables are filled by reading the CSV files. Both the Data tables column names are same but some of the column's data types are different. Due to this while merging I am getting error.

Richard MacCutchan 23-Mar-20 5:15am

You cannot merge different types of data, they must all be the same. You will need to check each item as you process it and convert one to the other type.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Answer 1 · 2020-03-21T02:23:00

Solution 1

Do it in the database, and use a join to bring in data from both tables.

Caveat: The tables being joined must to have a column that can be compared for equality so you can join the appropriate rows from both tables. I would create a view that does it, and then you can just query the view for your data.

Posted 21-Mar-20 2:23am

#realJSOP

Comments

vivektp 23-Mar-20 3:21am

My Data tables are filled by reading the CSV files. Both the Data tables column names are same but some of the column's data types are different. Due to this while merging I am getting error.

#realJSOP 23-Mar-20 5:31am

You have to do a join with Linq. Google "Linq join".