c# (excel file & datagridview comparison)

Question

hi..

excel file contains:

name password

abc 123

xyz 321

asas 856

jklo 854

datagridview contains:

name password

abc 123

xyz 321

so question is how to compare excel file & datagridview. & show thier difference in

another datagridview... please help.. new to this...

Nattudurai Eswaramurthy · Answer

HI Gopal I guess there is no direct way to compare it even if its possible its complex processing. instead can try to export the data in ur gridview to excel and compare the both excel data's? or import excel data to gridview and compare both grid's and display the difference in another grid?

Nattudurai Eswaramurthy · Answer

HI Gopal we can loop through the datasource(Data which we bind to grid1) and loop through with Primary key item and look the same in grid2. depends on the result you could to the rest.

Gopal Mahadak · Answer

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