How do I loop on column of gridview, sum its values and dsplay the sum on a new line?

Question

0.00/5 (No votes)

See more:

As the question says,I am trying to Display the sum of a column in gridview to the user outside the grid,but i am getting errors with the code i wrote below.
So ho can i correct the code in order for it to display the Sum?

P.s getting this Error :

C#

Operator '+' is not defined for types 'Double' and 'System.Web.UI.WebControls.TableCell

What I have tried:

VB

Dim Sum As Double = 0
       For i As Integer = 0 To Grid1.Rows.Count - 1
           Sum = Grid1.Rows(i).Cells(3) + Sum
       Next
       Response.Write("The Sum of all RepairPrice is : " + Sum.ToString)

I also tried this

VB

Dim Sum As Double = 0
       For Each row In Grid1.Rows

           Sum = Sum + (row.Cells(3))

       Next
       Console.WriteLine("The Sum of all RepairPrice is : " + Sum.ToString)

Posted 28-Jun-16 4:49am

xTMx9

Updated 28-Jun-16 5:45am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2016-06-28T05:45:00

The error is giving you a huge clue!

You know that Sum is a Double and you know you are getting the error on

VB

Sum = Grid1.Rows(i).Cells(3) + Sum

and/or

VB

Sum = Sum + (row.Cells(3))

so it stands to reason that it's Grid1.Rows(i).Cells(3)and/or row.Cells(3) that is a 'System.Web.UI.WebControls.TableCell'

So you need to convert the Cell to a Double in order to add it to the running total Sum
E.g.

VB

Sum = Double.Parse(Grid1.Rows(i).Cells(3).Text) + Sum

or

VB

Sum = Sum + Double.Parse(row.Cells(3).Text)