How to loop datatable using LINQ?

[Muralikrishna_Surve]

I want to loop the Datatable values using LINQ.

Same like as we normally do using ‘For Each Row’ activity.

How to loop the datatable using LINQ ?

[ppr (Peter)]

[HowTo] - Exploring the LINQ Universe (VB.Net)

LINQ (Language-Integrated Query) is part of the .NET framework and offers capabilities for interacting with data, objects, or other sources within a particular syntax. This HowTo elaborates on the availability of LINQ and explores the offered functionalities Current Version of this topic is DRAFT and will be finalized / enhanced soon Introduction Let’s recap the Example of LINQ from [HowTo] - First Start with LINQ (VB.Net). Sample data: myNumbers | List (Of Int32) = {12,34,5,8,10,2,15,7}.t…

[Shubham_Dutta]

Hi @Muralikrishna_Surve ,
Please go through the below youtube video:

UiPath | LINQ Cast Function | Loop Through Rows and Columns of Excel / Table using LINQ | Convert

You will get a clear understanding.

Thanks & Regards,
Shubham Dutta

[postwick (Paul)]

LINQ doesn’t really work that way. Why not just use For Each Row? It’s what it’s meant to do.

[Shubham_Dutta]

Hi @Muralikrishna_Surve , if you have no more queries please mark the solution and close the thread.

Thanks & Regards,
Shubham Dutta

[ashwin.ashok ((TheCodingTheory))]

Hi @Muralikrishna_Surve

I agree with @postwick .
Is there any specific reason for wanting to use LINQ?

It entirely depends on the requirement, but if you want to explore solutions using code, then take the Invoke Code Activity out for a test run:

For Each row As DataRow In dt.AsEnumerable()
Console.WriteLine(row(0))
Next row

invoke_Code_Example.xaml (7.3 KB)

Kind Regards,
Ashwin A.Kg