Hi all,

I "inherited" an ASP.NET page that reads in an excel sheet. However, I want to know the most effecient way to check for duplicate rows.

I was told I should sort the spreadsheet by a unique column, and then do my comparison. I would then compare the first row to the 2nd row, the 2nd row to the third row, and so on. I need to handle about 10,000 rows at once. Therefore, I am very concerned about timeout issues.

Is this the right approach? And if so, what resource can I look at to get started on it. If it's not the right approach, can someone give me an idea of what would be best?

Thanks