Greeting to daniweb
I must partition by Type and rank the following datable ( called dt) by LoanAmt column with ties

Type   LoanAmt   Rnk
A        14    
A        15
A        13
A        11   
A        11
B        17
B        18
B        17
B        16

As a new learner, I have read about Linq to datasets and something in the lines of

Dim Rnks As DataTable = dt
Dim query = From Rnk In dt.AsEnumerable() Order By Rnk.Field(Of double)("LoanAmt") Descending Select Rnk

With the above query, how do if fill up the Rnk column above? Any snippet?