I have a question in LINQ

Hello Everyone
I have a Question
I have datatable the table contain village name and population
if the village name contains padu,palem,puram

I use this LINQ Quire but it extract one one data padu
ExtractDataTable.AsEnumerable.Where(Function(r) r.Item(0).ToString.ToLower.Contains("padu") or r.Item(0).ToString.Contains("palem") or r.Item(0).ToString.Contains("puram")).CopyToDataTable

So please help me I have to extract the 3 village name padu,palem,puram

Chethan P

HI @copy_writes

have you try ToLower method for other 2 condtions as well.


1 Like

Yes I forgot I will check sorry