Can someone explain to me, please?

[170290064 (Eyüp Hasan Akbaba)]

I understand something but i want to understand fully!

Or any video or something that i can watch ???

[supriya117 (Supriya Allada)]

Hi @170290064

Check this tutorial playlist:

[Vikas_M]

Hey @170290064

.GroupBy(Function(g) New With {Key .Names = g(“Color”)}): This groups the DataRow objects based on the values in the “Color” column, here each group contains all the rows with the same color.

.OrderBy(Function(r) r.Key.Names.ToString()): This sorts the groups based on the “Color” column in ascending order.

.Select(Function(s) New With {.Names = s.Key.Names.ToString(), .Count = s.AsEnumerable().Count()}): This projects each group into a new object with two properties: “Names” and “Count”. “Names” will store the color name as a string, and “Count” will store the number of rows in each group (i.e., the number of occurrences of that color).

.ToList().ForEach(Sub(row) in_DtColorCount.Rows.Add(row.Names, row.Count)): This converts the result of the previous step into a List and then iterates through each element of the list. For each element (representing a color group), it adds a new row to a DataTable called in_DtColorCount. This new row contains two columns: “Names” (representing the color name) and “Count” (representing the number of occurrences of that color in the original DataTable).

[supermanPunch (Arpan)]

@170290064

I understand something but i want to understand fully!

Or any video or something that i can watch ???

Hi @170290064 ,

You could check out videos which are already available on Youtube. Would recommend you to go through the Video playlist of the below Youtuber :

UiPath | LINQ Training | Learn LINQ for UiPath from A to Z | LINQ Query Structure | LINQ Query Parts

Also, some of the tutorials here already on Linq :

[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}.to…

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…

[Quenton_Wayne_Rebello]

1. So in the above code, we parse through the DtOtomobil datatable and group the datatable based on the column Color in your table.

2. The grouped result is ordered in ascending format based on color. Eg: - rows with color black first then rows with color blue etc.

3. Next step is we choose the color value from each group and the count of how many rows are in that group. This result is then converted in a list format.

4. Finally using a for each we parse through the list result and add each entry to the datatable dtColorCount

To understand what each method does you can go through : LINQ - Query Operators | Tutorialspoint