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!

1 Like
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

2 Likes
5

Hey @Chirag12 ,
Use it in an assign activity

Refer below xaml
Sequence.xaml (8.6 KB)

Hope it helps you out!

1 Like
6

@Chirag12

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

Gives you in descending order

1 Like
7

Thank you @Vikas_M for the xaml

8

@Chirag12
for learnings have a look here:

9

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