How to add numbering after sort?

Help Activities
, ,
1

Hi,

I have a data like this :

image

and I want it to be like this :

image

Is there anyway to add numbering after the sorting?

2

hey,
you can use this
datatablevariable = From x In datatablevariable.AsEnumerable() Order By convert.Tostring(x(“Branch”)),convert.ToString(x(“No”)) Select x).CopyDataTable

Thanks,
Rounak

3

Thanks, it works !

4

HI,

Is your requirement re-assign “No” column in order? If so, the following will work.

dt = dt.AsEnumerable.OrderBy(Function(r) r("Branch").ToString).Select(Function(r,i) dt.Clone.LoadDataRow({(i+1).ToString,r("Name").ToString,r("Branch").ToString},False)).CopyToDataTable

Regards,

2 Likes
5

This one works too. Thanks

6

I do not think this is you expected. You need to re arrange the No 1…n after sort by branch.

7

This is correct

8

Well I did modify it a little bit matching with my current code and it works :slight_smile: so basically I tried to learn the logic. But both from Mr. Yoichi and Mr. Rounak are both solutions :slight_smile: Thanks for discussing btw

1 Like
9

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