CODEWITHSUNDEEP
vb.netlambda
user3401335
user3401335

Reputation: 2405

lambda expression vb.net for max value in a datatable

I have a datatable called table1 with a column called column1 that is an integer.

How can i get the max value of the column with a lambda expression in vb net?

thanks!

Upvotes: 2

Views: 2994

Answers (1)

Tim Schmelter
Tim Schmelter

Reputation: 460158

Dim max As Int32 = table1.AsEnumerable().
    Max(Function(r) r.Field(Of Int32)("column1"))

or in query syntax, what is often more readable in VB.NET:

Dim values =  From row In table1.AsEnumerable()
              Select row.Field(Of Int32)("column1")
Dim maxValue As Int32 = values.Max()

Upvotes: 4

Related Questions