I have a question in LINQ

Learning Initatives Reboot Your Skills 2021
1

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

Thanks
Chethan P

2

HI @copy_writes

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

Thanks

1 Like
3

Yes I forgot I will check sorry