I am developing a .NET web-app and I am importing a huge amount of data from an excel sheet, to a datatable.
Before I do any changes to the data fetched, I want to make sure that a certain field in the excel, does not contain character "E". If so, stop the import process.
Any idea what this linq query should look like? I have tried numerous of ideas, with no result.
I would rather use an SQL query, but couldnt find a way to query the dataset by using it.