find min and max values in a datatable using C#

Question

Possible Duplicate:
How to select min and max values of a column in a datatable?

I am searching for code that could find the min and max (or first and last values) from a column in a datatable.

I have stored the datatable with four column values I want to find the min and max values from the third column(index 2) and display it to the user.

I tried many ways but all are causing exceptions...

Last i tried this code but even this is not working..

count = Convert.ToInt32(dt.Rows.Count);

start = Convert.ToInt32(dt.Rows[0][2].ToString());

end = Convert.ToInt32(dt.Rows[count-1][2].ToString());

thanks vince

@David "there is no row at position 0" this is the exception i am getting for the second line... and the datatable is full.. it is not empty.. — vince, Jul 01 '11 at 19:50

score 17 · Answer 1 · answered Jul 01 '11 at 19:46

You could always use the .Select method on the DataTable to get those rows:

var maxRow = dt.Select("ID = MAX(ID)");

This will return a DataRow[] array - but it should typically only contain a single row (unless you have multiple rows with the same, maximum value).

Same goes for the minimum:

var minRow = dt.Select("ID = MIN(ID)");

See the MSDN docs on DataTable.Select for more details.

score 0 · Answer 2 · edited May 23 '17 at 12:06

0

Answer is available on stackoverflow : How to select min and max values of a column in a datatable?

Thanks, Swapnil.

edited May 23 '17 at 12:06

Community

1
1

answered Jul 01 '11 at 19:49

Swapnil

1

score 0 · Answer 3 · answered Jul 01 '11 at 19:50

What datatype are count start and end declared as? That isn't shown in your code.

Also, the code you've provided, if working, would only give you the first and last element, NOT the minimum in the set and the maximum in the set. If you are looking for min/max, you'd need to write a loop, such as this:

// minimum
int min = dt.Rows[0][2]; // assuming you want the third column (index 2)
for(int i = 1; i < dt.Rows.Count; i++) 
{
    if(min > (int)dt.Rows[i][2]) min = (int)dt.Rows[i][2];
}

// maximum
int max = dt.Rows[0][2]; // assuming you want the third column (index 2)
for(int i = 1; i < dt.Rows.Count; i++) 
{
    if(max < (int)dt.Rows[i][2]) max = (int)dt.Rows[i][2];
}

Obviously these can also be combined into a single loop:

// minimum and maximum
int max = dt.Rows[0][2]; // assuming you want the third column (index 2)
int min = dt.Rows[0][2]; // assuming you want the third column (index 2)
for(int i = 1; i < dt.Rows.Count; i++) 
{
    if(max < (int)dt.Rows[i][2]) max = (int)dt.Rows[i][2];
    if(min > (int)dt.Rows[i][2]) min = (int)dt.Rows[i][2];
}

@marc_s' answer is more elegant for your specific use case (data table), but mine will work for any data set in an indexed collection.

@Nate... sorry for that...all that are int and my datatable is ordered by that column so min and max are the first and the last elements.... — vince, Jul 01 '11 at 20:55

find min and max values in a datatable using C#

3 Answers3

Related