c# datagridview comparison....

Gopal Mahadak

14y10.6kVisual Basic .NET

how to compare datagridview's and display the difference in another grid?

6 Replies

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

Santhosh Kumar Jayaraman14y ago
Accepted answer
For compare 2 datatables, use this below method.

public bool compareTbls(Datatable tbl1, Datatable tbl2)
{
if(tbl1.Rows.Count != tbl2.Rows.Count || tbl1.Columns.Count != tbl2.Columns.Count)
return false;

for(int i = 0; i < tbl1.Rows.Count; i++)
{
for(int c = 0; c < tbl.Columns.Count; c++)
{
if(tbl1.Rows[i][c] != tbl2.Rows.Columns[i][c])
return false;
}
}
return true;
}

Also if you want to compare using linq,
then check below linq.

http://www.codeproject.com/Tips/344792/Compare-two-datatable-using-LINQ-Query

hj jh14y ago

try using linq for the same depending on your requirement

private void SampleSolution(DataTable dt1, DataTable dt2)
{
    //If you have primary keys:
    var results = from table1 in dt1.AsEnumerable()
                    join table2 in dt2.AsEnumerable() on table1.Field("id") equals table2.Field("id")
                    where table1.Field("ColumnA") != table2.Field("ColumnA") || table1.Field("ColumnB") != table2.Field("ColumnB") || table1.Field<String>("ColumnC") != table2.Field<String>("ColumnC")
                    select table1;
    //This will give you the rows in dt1 which do not match the rows in dt2.  You will need to expand the where clause to include all your columns.


    //If you do not have primarry keys then you will need to match up each column and then find the missing.
    var matched = from table1 in dt1.AsEnumerable()
                    join table2 in dt2.AsEnumerable() on table1.Field("ColumnA") equals table2.Field("ColumnA")
                    where table1.Field("ColumnB") == table2.Field("ColumnB") || table1.Field("ColumnC") == table2.Field("ColumnC") || table1.Field