how to perform sum operation on datagridview cell in vb.net

Question

0.00/5 (No votes)

See more:

Hi all,

I just need a help regarding datagridview control in vb.net

I have datagridview in my form ..i had bind it and i want to perform sum operation of different cell..

for eg:-
i have a "AMOUNT" column in my datagrideview and i want to add those "AMOUNT" cell value.. and display it in a textbox..

my datagridview looks like below..
amount | rate | total
--------------------------
1
3
4
so if i want the sum of "AMOUNT" ie:- "8" in a textbox.. then wat code should i write.. can u pleas help me out any one..pls..

Posted 8-Apr-11 19:03pm

rajantandel

Add a Solution

Comments

rajantandel 12-Apr-11 1:47am

thanks to all Specailly Andy_L_J.

8 solutions

Add a Solution

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

Henry Minute · Answer 1 · 2011-04-08T20:07:00

Solution 1

Take a look at Tip #7 from this page.[^]

Posted 8-Apr-11 20:07pm

Henry Minute

TweakBird · Answer 2 · 2011-04-08T21:52:00

Solution 4

Have a look on CP Article : SumColumn: Custom DataGrid Column that automatically shows Sum/Count/Average in DataGrid Footer.[^]

This links (Additional to above links)
http://forums.asp.net/t/1647555.aspx/1[^]

Posted 8-Apr-11 21:52pm

TweakBird

avigodse · Answer 3 · 2011-04-09T04:12:00

If you need to display your sum of all rows from GridView then follow any of the solutions above.
And if you want to calculate the total using amount*rate, then add data-column to your data-source data-table as;

dataTable.Columns.Add("total", typeof(System.Double), "amount*rate");

or

dataTable.Columns.Add("grand_total", typeof(System.Double), "sum(amount)");

Abhinav S · Answer 4 · 2011-04-08T20:10:00

Solution 2

This[^] could help.

Posted 8-Apr-11 20:10pm

Abhinav S

Wendelius · Answer 5 · 2011-04-08T21:38:00

Solution 3

And if the data is coming from a datatable you can use Compute[^] method

Posted 8-Apr-11 21:38pm

Wendelius

Andy_L_J · Answer 6 · 2011-04-09T01:24:00

Solution 5

This will get you started...

Dim tot As Double = 0
With dgv
  For Each d As DataGridViewRow In dgv
    tot += CDbl(d.Cells("Amount").Value)
  Next
End With

Posted 9-Apr-11 1:24am

Andy_L_J

aviporje · Answer 7 · 2011-11-18T01:07:00

Solution 7

Dim totalsum As Integer
For i As Integer = 0 To dst.Tables(0).Rows.Count - 3
totalsum += dst.Tables(0).Rows(i).Item("Purches_Item")

Next
txtTotlePur.Text = totalsum.ToString()

Posted 18-Nov-11 1:07am

aviporje

Sunil S. Bhagwat · Answer 8 · 2012-12-11T09:44:00

Dear All

At row level one can use below codes for getting totals of colum using button click or
Private Sub Table1DataGridView_CellEndEdit(sender As Object, e As System.Windows.Forms.DataGridViewCellEventArgs) Handles Table1DataGridView.CellEndEdit
event to get total

Dim tot As Double = 0
With Table1DataGridView
For Each d As DataRowView In Table1BindingSource
tot += CDbl(d.Row("Amount"))
Next
End With
lblTotal.Text = tot.ToString

Sunil Bhagwat

how to perform sum operation on datagridview cell in vb.net

8 solutions

Solution 1

Solution 4

Solution 6

Solution 2

Solution 3

Solution 5

Solution 7

Solution 9

Add your solution here

Preview 0

how to perform sum operation on datagridview cell in vb.net

8 solutions

Solution 1

Solution 4

Solution 6

Solution 2

Solution 3

Solution 5

Solution 7

Solution 9

Add your solution here

Preview 0

Existing Members

...or Join us