I have created a gridview based on an SQL Datasource. The grid view contains several columns(fields) one of which is called "Amount". In the footer of the gridview their is a field that contains the sum of all of the values contained in the "Amount" field.
By problem is that in instead of getting the value of the Amount displayed in the "Amount" field of each row, I am getting a '0' (Example: 0 25.78 when I should just be getting 25.78. There is a space between the '0' and the '25.78'.
Code is as follows:
<asp:TemplateField HeaderText="Amount" SortExpression="Amount">
View Complete Post