find max, min, sum of a column?

[joeframbach]

i have a datatable with a column of doubles.

how would i find the largest and smallest double in the column, and add the column? i dont want to loop through it... that's too easy

[Mr.No]

Sort the column and then pick up the first and the last item.

[joeframbach]

will that affect the output when i apply it to a datagrid? i dont want it to be sorted in the output.

[SjR]

Well, if you're getting the list of values from a database table, could you not execute a second query such as...

SELECT MAX(dbo.Table1.Value), MIN(dbo.Table1.Value), SUM(dbo.Table1.Value) FROM dbo.Table1

...to get the calculations you're after?

[joeframbach]

i'm not using a database table. i'm populating the datatable using other calculations.

btw - i dont know what a database table is and how to use it either