How To Calculate TOTAL in DGV

Question

0.00/5 (No votes)

See more:

Hi.. All How To Calculate Total.. I Expect This OUTPUT

Regno Name Class Jan Feb Mar Apr TOTAL
A100 AAA I 500 150 120 54 824
A200 BBB I 450 50 0 0 500

Please Tell me.. how to i do..

Here I am Using This CODE

VB

For j1 As Integer = 0 To DataGridView1.Rows.Count - 1
            For ij As Integer = 3 To DataGridView1.Columns.Count - 1
                With Me.DataGridView1.Rows.GetFirstRow(Me.DataGridView1.Rows.Count - 1)
                    If IsDBNull(DataGridView1(ij, j1).Value) <> True Then
                        total = total + DataGridView1(ij, j1).Value
                    End If

                End With
            Next ij
            DataGridView1.Rows(j1).Cells("TOTAL").Value = total
        Next j1

Now This CODE SHOW LIKE THIS OUTPUT

Regno Name Class Jan Feb Mar Apr TOTAL
A100 AAA I 500 150 120 54 824
A200 BBB I 450 50 0 0 1324

Posted 20-Feb-13 20:11pm

Navas Khanj

Updated 20-Feb-13 20:43pm

uspatel

v2

Add a Solution

2 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)

Ksh_Sr · Accepted Answer · 2013-02-20T20:41:00

Solution 1

If you are binding the grid with data using Sql Query then its better to sum up there on query side only likewise

SELECT RegNo , Name , Class , Jan , Feb , Mar , Apr ,(Jan+Feb+Mar+Apr) as Total FROM TABLE

happy coding :)

Posted 20-Feb-13 20:41pm

Ksh_Sr

Comments

Navas Khanj 21-Feb-13 2:50am

Hi Jan,feb,Mar,etc.. This Hearder Texy I am using PIVOT Table so above code is not work for this condiction..

please tell me.. any other way..

[no name] 21-Feb-13 2:57am

Your code seems to be working fine..whats the problem that you are facing??

Navas Khanj 21-Feb-13 3:03am

Dim strSQL1 As String = "SELECT * FROM ( SELECT [Regno], [FeeType], [SName], [AmountPaid], [Class] FROM FeeTrans) AS DT " & _
" PIVOT(SUM([AmountPaid]) FOR [FeeType] IN ([Jan],[Feb],[Mar],[Apr])) as PT WHERE Class='" & cboClass.Text & "'"
Dim DaAp1 As New SqlDataAdapter(strSQL1, con)
Dim Dset1 As New DataTable
DaAp1.Fill(Dset1)

Dset1.Columns.Add("TOTAL")
DataGridView1.DataSource = Dset1

Dim total As Integer = 0
For j1 As Integer = 0 To DataGridView1.Rows.Count - 1
For ij As Integer = 3 To DataGridView1.Columns.Count - 1
With Me.DataGridView1.Rows.GetFirstRow(Me.DataGridView1.Rows.Count - 1)
If IsDBNull(DataGridView1(ij, j1).Value) <> True Then
total = total + DataGridView1(ij, j1).Value
End If

End With
Next ij
DataGridView1.Rows(j1).Cells("TOTAL").Value = total
Next j1
HI Here I am using Full Code..

Navas Khanj 21-Feb-13 3:04am

Please Tell me.. how can i do

[no name] 21-Feb-13 3:53am

Rewrite your code
For j1 As Integer = 0 To DataGridView1.Rows.Count - 1
For ij As Integer = 3 To DataGridView1.Columns.Count - 1
With Me.DataGridView1.Rows.GetFirstRow(Me.DataGridView1.Rows.Count - 1)
If IsDBNull(DataGridView1(ij, j1).Value) <> True Then
total = total + DataGridView1(ij, j1).Value
End If

End With
Next ij
DataGridView1.Rows(j1).Cells("TOTAL").Value = total
Next j1

as

For j1 As Integer = 0 To DataGridView1.Rows.Count - 1
total = 0
For ij As Integer = 3 To DataGridView1.Columns.Count - 1
With Me.DataGridView1.Rows.GetFirstRow(Me.DataGridView1.Rows.Count - 1)
If IsDBNull(DataGridView1(ij, j1).Value) <> True Then
total = total + DataGridView1(ij, j1).Value
End If

End With
Next ij
DataGridView1.Rows(j1).Cells("TOTAL").Value = total
Next j1

nane aa · Accepted Answer · 2013-02-20T22:08:00

Solution 2

C#

DataGridView1.Rows(j1).Cells("TOTAL").Value = total

After that put

total=0

Posted 20-Feb-13 22:08pm

nane aa

Updated 20-Feb-13 22:10pm

v2

Comments

Navas Khanj 21-Feb-13 4:51am

Thanks for Your Response.