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 EswaramurthyPosted Aug 20, 2012, 6:56 AM
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 MahadakPosted Aug 20, 2012, 5:37 AM
Nattudurai EswaramurthyPosted Aug 20, 2012, 5:34 AM
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?