How to select min and max values of a column in a datatable

Question

For the following datatable column  what is the fastest way to get the min and max values   AccountLevel   0   1   2   3

User · Answer

This worked fine for me  int  max   Convert ToInt32 datatable name AsEnumerable                            Max row   gt  row  column Name

User · Answer

Use LINQ  It works just fine on datatables  as long as you convert the rows collection to an IEnumerable   List lt int gt  levels   AccountTable AsEnumerable   Select al   gt  al Field lt int gt   AccountLevel    Distinct   ToList    int min   levels Min    int max   levels Max      Edited to fix syntax  it s tricky when using LINQ on DataTables  and aggregating functions are fun  too   Yes  it can be done with one query  but you will need to generate a list of results  then use  Min   and  Max   as aggregating functions in separate statements

User · Answer

Easiar approach on datatable could be   int minLavel   Convert ToInt32 dt Compute  min  AccountLevel     string Empty

User · Answer

int minAccountLevel   int MaxValue  int maxAccountLevel   int MinValue  foreach  DataRow dr in table Rows        int accountLevel   dr Field lt int gt   AccountLevel        minAccountLevel   Math Min minAccountLevel  accountLevel       maxAccountLevel   Math Max maxAccountLevel  accountLevel       Yes  this really is the fastest way   Using the Linq Min and Max extensions will always be slower because you have to iterate twice   You could potentially use Linq Aggregate  but the syntax isn t going to be much prettier than this already is

User · Answer

Performance wise  this should be comparable  Use Select statement and Sort to get a list and then pick the first or last  depending on your sort order    var col   dt Select  AccountLevel    AccountLevel ASC     var min   col First    var max   col Last

User · Answer

var answer   accountTable Aggregate new   Min   int MinValue  Max   int MaxValue                                              a  b    gt  new   Min   Math Min a Min  b Field lt int gt   AccountLevel                                                             Max   Math Max a Max  b Field lt int gt   AccountLevel        int min   answer Min  int max   answer Max    1 iteration  linq style

User · Answer

var min   dt AsEnumerable   Min row   gt  row  AccountLevel     var max   dt AsEnumerable   Max row   gt  row  AccountLevel

User · Answer

Session  MinDate     dtRecord Compute  Min AccountLevel    string Empty   Session  MaxDate     dtRecord Compute  Max AccountLevel    string Empty

User · Answer

another way of doing this is   int minLavel   Convert ToInt32 dt Select  AccountLevel min AccountLevel    0  0      I am not sure on the performace part but this does give the correct output

User · Answer

The most efficient way to do this  believe it or not  is to make two variables and write a for loop

User · Answer

I don t know how my solution compares performance wise to previous answers   I understand that the initial question was  What is the fastest way to get min and max values in a DataTable object  this may be one way of doing it   DataView view   table DefaultView  view Sort    AccountLevel   DataTable sortedTable   view ToTable    int min   sortedTable Rows 0  Field lt int gt   AccountLevel    int max   sortedTable Rows sortedTable Rows Count-1  Field lt int gt   AccountLevel      It s an easy way of achieving the same result without looping  But performance will need to be compared with previous answers  Thought I love Cylon Cats answer most

[c#] How to select min and max values of a column in a datatable?

Examples related to c#

Examples related to .net

Examples related to select

Examples related to datatable