Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
I want to calculate sum of Amount in grid view.
In Gridview I am showing following fields:
PO_NO, Item, Rate ,Qty, Disc, Amt.
1 1 100 1 0 100
2 2 500 2 1000
 
I want sum of Amt column.
Posted 4-Dec-12 3:34am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You just need to loop throught the rows of the gridview
For Each row As DataGridViewRow In yourDataGridViewName.Rows
    totalAmount = totalAmount + row.Cells("Amt").Value
    'Do Something
Next
Good luck,
OI
  Permalink  
v2

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

  Print Answers RSS
0 CPallini 330
1 Sergey Alexandrovich Kryukov 313
2 George Jonsson 291
3 Prasad Avunoori 155
4 OriginalGriff 149
0 OriginalGriff 4,623
1 CPallini 3,410
2 Sergey Alexandrovich Kryukov 2,929
3 George Jonsson 2,319
4 Gihan Liyanage 2,077


Advertise | Privacy | Mobile
Web03 | 2.8.140905.1 | Last Updated 4 Dec 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100