Member Avatar for gbhs

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

  • 1 Contributor
  • 1 Reply
  • 126 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by gbhs
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.