Simple LINQ Aggregate Query
- by Steven
What is the vb.net equivalent of the following psuedo-code using LINQ?
select min(credits) minCredits, max(credits) maxCredits,
min(dollars) minDollars, max(dollars) maxDollars
from players
minCredits_lbl.Text = minCredits
...
maxDollars_lbl.Text = maxDollars
I have the following, but I can't figure out how to get any further.
Dim query = From row in myDataSet.Tables("Players") _
Select credits = row("credits"), dollars = row("dollars")