How to remove datatable data contains particular character and delete entire row using linq

[AshwinS2 (Ashwin S)]

Hi @Aravinthan

try this

Filter data table without Case sensitive values

I have a table containing 4-5k rows with 9-10 columns. I just want to filter the table into another table. I am just getting the problem when any row is having value in different case which is other than filter criteria I have mentioned. for example - one column Status is having values ‘Single’, ‘single’, ‘SINGLE’, ‘married’,‘Married’, MARRIED’ and another column Country is having values like ‘usa’, ‘USA’, ‘Usa’, ‘Australia’, ‘australia’, ‘AUSTRALIA’. So I would like to fetch the values who a…

Thanks
Ashwin S