Hi All,

Can anyone tell me how to calculate the total sum from a column in a datagrid and output the result to a textbox. I have a datagrid which retrieves two columns of data for example:

Type_______Count
RED _________2
BLUE_________4
GREEN________1
WHITE________2

The count is done using a query on a SQL server database to retrieve this information. What i need is for the total of the count to be displayed in a separate text box.

Any Ideas would be appreciated.

Colin