Datagrid Question

Extremebfn
10-19-2004, 01:52 PM
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 :)

Shurik12
10-19-2004, 04:26 PM
Whu don't you calculate the total in your query?

MKoslof
10-19-2004, 06:55 PM
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 :).

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum