Datagrid Question

Hi. I want to Add up a sertain column's data to get a total?How would i do this with a Datagrid?

I have link 3 Column:

NAME PRODUCT PRICE

XXX XXXX XXXX
XXX XXXX XXXX
XXX XXXX XXXX
XXX XXXX XXXX
[textbox with Total of Column PRICE]

I want to disply the total of the Price Column inside a textbox?Help Please :)

Whu don't you calculate the total in your query?

To add to what Shurik has said, look into the COUNT() and SUM() aggregate functions. You can get this information directly out of your sql declaration :).