Hi All

I would love to give you an example of what I have tried so far but haven’t a clue!!...

I have a database connection and have filled a datatable and would like to be able to get the aggregate figure for certain columns within the datatable. Please could somebody guide me in the right direction on how to do this?

Many thanks

Rit

__________________
Rit
www.designandonline.co.uk
INSPIRE | CREATE | DELIVER

OK, I think I might be going down the right route...

Dim QtyVal as Integer = Convert.ToInt32(MyDataTable.Compute("Sum(qty)", "site = 4 "))

... Does anyone know how I could achieve the above but without it filtering?.. I could do with it adding up ALL of the values within the field 'qty' from the whole datatable.

Many thanks

Rit