How to grab the sum of a cloumn to use in aspx?

kamikazekatz

Hello,

I generate the code for datatables in codebehind .cs file. I have some columns with currency values. How can I sum the whole column and grab it so that I can use it in the .cs file?

Also is it possible to grab the value of the shown results if the searchfilter is used? E.g.something is typed in the searchfilter and rows get hide and I need the sum only of the visible rows.

Thanks