How to filters rows in data table using LINQ query

Help Something Else
1

Hi Team,

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

I have table like below

image
image724×373 8.77 KB

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

1 Like
2

Hi @Mandava_Naresh

You can try this

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

Hi @Mandava_Naresh

How about this expression

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

Regards
Gokul

4

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

1 Like
5

This is working … Thank You very much @Gokul001

6

Thank you @kumar.varun2

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.