Compare datatable and return rows with changes

Question

0.00/5 (No votes)

See more:

Hi,

I am trying to compare two datatable and return rows which has changes by using the below code and it doesn't work. I need to compare dt1 & dt2, Pls suggest some options.

C#

DataTable dt3 = new DataTable();
var contacts = dt1.AsEnumerable().Intersect(dt2.AsEnumerable(),DataRowComparer.Default);
foreach (DataRow rows in contacts)
{
  dt3.Rows.Add(rows);
}

Posted 24-Apr-15 0:28am

vignesht50

Updated 24-Apr-15 9:28am

Maciej Los

v2

Add a Solution

Comments

Maciej Los 24-Apr-15 15:29pm

What you mean by "compare"? How your data look like?

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)

Sascha Lefèvre · Accepted Answer · 2015-04-24T03:55:00

If I understand your question correctly, your DataTables have the same Column-schema and you want to get those rows that they do not have in common.

- Your current code intersects the rows of the DataTables, returning those rows that the DataTables have in common. Instead you have to union the rows that that are missing from one table with those missing from the other.

- To copy DataRows to a new DataTable, the destination DataTable has to have the same Column-schema and you have to make a copy of the DataRow because you can't add a DataRow to a DataTable if it already belongs to another DataTable.

This will work for you:

C#

var dt1Rows = dt1.AsEnumerable();
var dt2Rows = dt2.AsEnumerable();
var comparer = DataRowComparer.Default;

// get the rows that dt1 and dt2 not have in common:
var diffRows = dt1Rows.Except(dt2Rows, comparer).Union(dt2Rows.Except(dt1Rows, comparer));

DataTable dt3 = dt1.Clone();  // create a new DataTable with same Column-schema

foreach (DataRow diffRow in diffRows)
{
    DataRow rowCopy = dt3.NewRow();         // new empty row
    rowCopy.ItemArray = diffRow.ItemArray;  // copy values
    dt3.Rows.Add(rowCopy);
}