How to recycle data in an SqlDataSource object?

Question

I have an SqlDataSource object, linked to a GridView, which receives data from a database when executed.

I'd like to add the values of the "Cost" column, to get the "TotalCost", and place it in a TextBox or Label on top of the GridView.

Is it possible to just use (recycle) the data in the SqlDataSource object, instead of using another SqlDataSource object to just get the TotalCost"?

Answer 1

If you handle the rowdatabound event you can get the values from each row to get your total.