Hello, all I am new to linq

Help Studio
, ,
1

I am starting Linq , So i thought of giving myself a problem but i was not able to solve it
I have a datatable , how do i order it based on one column, such that every other column should order by itself
image
this is my datatable

2

Hey @Chirag12 , You can use below Linq

dtA =

(From row In dt_A
Order By row("Count")
Select row
).CopyToDatatable

Hope it helps you out!

3

Which activity should i use this code?

4

@Chirag12

Use it in assign activity

Leftside
Datatabke variable =datatablevar.asenumerable.orderby(Function(x) x(“columnName”)).CopyToDataTable

5

Hey @Chirag12 ,
Use it in an assign activity

Refer below xaml
Sequence.xaml (8.6 KB)

Hope it helps you out!

6

@Chirag12

Datatabke variable =datatablevar.asenumerable.orderbydescending(Function(x) x(“columnName”)).CopyToDataTable

Gives you in descending order

7

Thank you @Vikas_M for the xaml

8

@Chirag12
for learnings have a look here: