Add Values of a column

[Guest tikki]

I have a database w/ 2 colums (itemName, amount). I have a label at the bottom of my form that i want to display the total value of all the amount variables, but I am clueless how to get it to work.

 

I have established OleDBCommand1 to select all the values from the amount column, but don't know how to get it to add the values together.

 

Any help is appreciated.

[Anis]

Sql Statement SUM.

select sum(amount) fom table'

[Guest tikki]

Too easy. Thanks a lot.