Loading

Comparison of Datatables in c#

Gopal Mahadak

First datatable contains:
Name Password
abc 123
xyz 323
avc 456

Second Datatable Contains:
Name Password
abc 123

So I want remove the Record From first Datatable That is in the Second Datatable..
Help me..

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted answer
This is off the top of my head but try the following:

foreach(DataRow dr2 in dt2.Rows)
{
for(int i = dt.Rows.Count - 1; i >= 0 ; i--)
{
DataRow dr = dt.Rows[i];
bool isSame = true;

for(int j = 0; j < dt.Columns.Count; j++)
{
if (!Object.Equals(dr2[j], dr[j]))
{
isSame = false;
break;
}
}

if (isSame) dt.Rows.RemoveAt(i);
}
}
0
Gopal Mahadak14y ago
Thanks ...For Helping me
0