Maximum value in a column returned in a C # datatable

Here is an example of the KeyIndex column (type int) in table DT21, through LINQ to achieve

int maxkeyindex = DT2. AsEnumerable (). Select (t = t.field<int> ("KeyIndex")). Max ();

LINQ syntax: Click to open link
2.throughCompute method to implement

int ee = (int) dt2.compute ("Max (KeyIndex)", "true");

Compute Method: Click the Open link
3.throughSelect method to implement the

int rr = (int) dt2. Select ("", "KeyIndex DESC") [0]["KeyIndex"];

Select method: Click the Open link
4. Go to ListTo list the columns that need to be sorted in the DataTable, and then sort by the list's sort () method, the last value in the list is the maximum, after the sort is sorted by the default ascending order.
Introduction to List

Copyright: jiankunking Source: http://blog.csdn.net/jiankunking This article is copyright to the author and Csdn, Welcome to reprint, but without the consent of the author must retain this paragraph, and in the article page obvious location to the original connection.

Maximum value in a column returned in a C # datatable