Difference of two DataTables in c#

Question

I have two data tables as follows

dtOne
-------------------------
  ID  |   Name 
--------------------------
 101  |  ABC
 102  |  XYZ
 103  |  MNO
--------------------------

dtTwo
-------------------------
  ID  |   Name 
--------------------------
 101  |  ABC
 102  |  XYZ
--------------------------

I just want the result as data which is in dtOne and not in dtTwo (dtOne-dtTwo)

dtResult
-------------------------
  ID  |   Name 
--------------------------
 103  |  MNO
--------------------------

How can i achieve this .

Pranay Rana · Accepted Answer · 2012-02-15 09:58:18Z

20

TO get it work its better to use Linq To DataSet will resolve it easily..

DataTable table1= ds.Tables["table1"];
DataTable table2= ds.Tables["table2"];
var diff= table1.AsEnumerable().Except(table2.AsEnumerable(),
                                                    DataRowComparer.Default);

edited Feb 15, 2012 at 9:58

answered Feb 15, 2012 at 7:34

Pranay Rana

177k37 gold badges244 silver badges267 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:31:53Z

2

Starting with the solution showed under LINQ query on a DataTable, I'd try it with:

var dtOneData = from myRow in dtOne.AsEnumerable();
var dtTwoData = from myRow in dtOne.AsEnumerable();
var difference = dtOneData.Except(dtTwoData);

edited May 23, 2017 at 12:31

CommunityBot

11 silver badge

answered Feb 15, 2012 at 7:43

bernhardrusch

11.9k12 gold badges50 silver badges60 bronze badges

Collectives™ on Stack Overflow

Difference of two DataTables in c#

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related