find min and max values in a datatable using C# [duplicate]

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

Answer 1

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.