Comparison of Datatables in c#

Question

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..

Vulpes · 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 { if (!Object.Equals(dr2[j] dr[j])) { isSame = false; break; } } if (isSame) dt.Rows.RemoveAt(i); } }

Gopal Mahadak · Answer

Thanks ...For Helping me