c# datagridview comparison....

Question

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

Santhosh Kumar Jayaraman · 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 { for(int c = 0; 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

Sukesh Marla · Answer

Comparing datatable will be a good idea instead of grid Check this as correct answer if helped

hj jh · Answer

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 ( "ColumnD" ) == table2 . Field ( "ColumnD" ) select table1 ; var missing = from table1 in dt1 . AsEnumerable () where ! matched . Contains ( table1 ) select table1 ; //This should give you the rows which do not have a match. You will need to expand the where clause to include all your columns. } or you can also iterate through each of the rows of datatable1 & compare its value to each of the row in databale2

Gopal Mahadak · Answer

but how to compare them? send code

Gopal Mahadak · Answer

one datagridview contains: name password abc 123 xyz 321 asd 147 jkl 963 another datagridview contains: name password abc 123 xyz 321 So compare both... & display its difference in another datagridview.. please help.. trying from one day... send code...

hj jh · Answer

Hi, can you pls elaborate your question so that it can be replied accordingly?

c# datagridview comparison....

Answers (6)