how to calculate sum of Amount in grid view.

Question

1.00/5 (1 vote)

See more:

I am using following code for sum of grid view column.

VB

Dim a, b, c As Decimal
        For i = 0 To GridItem.Rows.Count
            a = Convert.ToDecimal(GridItem.Rows(i).Cells(7).Value.ToString())
            c = c + a
        Next
        
        txtBasic.Text = c

System throws an error:Object reference not set to an instance of an object.
after debug the code I understand the problem.I add 2 rows in grid view.
Problem is system shows Gridview1.Rows.Count=3.
as per count for loop iterate 3 times 3rd time system throws an error:Object reference not set to an instance of an object.

1st time I entered =500.2nd time=2000.at second iteration of for loop value of c=2500.

Posted 9-Jan-13 3:12am

Yogi ,Pune

Updated 9-Jan-13 3:16am

Krunal Rohit

v2

Add a Solution

3 solutions

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)

Krunal Rohit · Answer 1 · 2013-01-09T03:22:00

Solution 3

Entire solution is given over here regarding your problem :
http://csharpdotnetfreak.blogspot.com/2009/07/display-total-in-gridview-footer.html[^]

Posted 9-Jan-13 3:22am

Krunal Rohit

fjdiewornncalwe · Answer 2 · 2013-01-09T03:21:00

Whenever you work with an object hierarchy, you should always perform an existence check before attempting to drill down. That way you eliminate issues like what you are encountering here.
For example.

VB

Dim a, b, c As Decimal
For i = 0 to GridItem.Rows.Count
If !IsNothing(GridItem.Rows(i)) And !IsNothing(GridItem.Rows(i).Cells(7) Then
   If Decimal.TryParse( GridItem.Rows(i).Cells(7).Value, out a ) Then
      c = c + a
   End If
End If
txtBasic.Text = c.ToString()

Raimis9 · Answer 3 · 2013-01-09T03:16:00

Solution 1

VB

For i = 0 To GridItem.Rows.Count - 1

Posted 9-Jan-13 3:16am

Raimis9