Add Values of a column

[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 dont know how to get it to add the values together.

Any help is appreciated.

 

[Anis]

Sql Statement SUM.

select sum(amount) fom table

 

[tikki]

Too easy. Thanks a lot.