How to filters rows in data table using LINQ query

[Mandava_Naresh]

Hi Team,

I want to filter rows using LINQ query … Can someone please help me in this ?

I have table like below

I want filter rows only rows which is having “HSM” value in accounts column… I tried filter data table activity but it is taking too much time and failing sometime since I have lakhs of records in my excel. So want to try using LINQ query

@J0ska @sreejith.ss

Thanks,
Naresh

[kumar.varun2 (Varun Kumar)]

Hi @Mandava_Naresh

You can try this

dt_Data=dt_Data.AsEnumerable().Where(Function (row) row("Accounts").ToString.ToUpper.Trim.Equals("HSM")).CopyToDataTable

[Gokul001 (Gokul Balaji)]

Hi @Mandava_Naresh

How about this expression

Dt.AsEnumerable.Where(Function(r) r.Item("Account").ToString.Equals("HSM")).CopyToDataTable

Regards
Gokul

[postwick (Paul)]

LINQ isn’t any faster. It’s a myth. LINQ has to loop, too.

[Mandava_Naresh]

This is working … Thank You very much @Gokul001

[Mandava_Naresh]

Thank you @kumar.varun2