Join a Two diffenternt DataTable in c#

Question

0.00/5 (No votes)

See more:

i have two differnt DataTable
FirstTable have morethen 100 columns
second table have morethan 100 columns.both table have same column ID

i want to merge two datatable rows into single

Posted 29-Apr-14 2:54am

ayubmytheen

Add a Solution

3 solutions

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)

Sanket Saxena · Answer 1 · 2014-04-29T03:06:00

Solution 1

I think you better start by adding relationship first. If you have primary key ID in table1 and you can add ID column in Table 2 with the relevant ID.

Then you can use DataTable.Merge method directly.

Posted 29-Apr-14 3:06am

Sanket Saxena

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 2 · 2014-04-29T03:11:00

Solution 2

Try with DataTable.Merge Method (DataTable)[^].

Posted 29-Apr-14 3:11am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

ayubmytheen 29-Apr-14 13:00pm

i tried above suggestion i am getting a error like
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 29-Apr-14 13:51pm

Look at the error message. Either schema of tables is not same or some row contains null or duplicate values.

Otherwise read the below which is in MSDN link I gave you.

"During a merge, constraints are disabled. If any constraints cannot be enabled at the end of merge, a ConstraintException is generated and the merged data is retained while the constraints are disabled. In this case, the EnforceConstraints property is set to false, and all rows that are invalid are marked in error. The errors must be resolved before attempting to reset the EnforceConstraints property to true."

ayubmytheen · Answer 3 · 2014-04-29T07:17:00

Table A Table B
Column1 column2 Column1 Column3
1 A 1 D
3 F 3 H

i want result table like this

Column1 column2 Column3
1 A D
3 F H

any body can help me to resolve the issue....