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?
Thanks