• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 532
  • Last Modified:

Calculating column datagridview


How do you calculate an entire column in a datagridview in vb.net ?
2 Solutions
Jacques Bourgeois (James Burger)PresidentCommented:
Dim total As Integer
            For x As Integer = 0 To DataGridView1.Rows.Count - 1
                  total += CInt(DataGridView1.Item(3, x).Value)

Change the 3 by the column you want to calculate on, knowing that the first column is 0.
If you have decimals, change total to a Double and CInt to CDbl.
Fernando SotoRetiredCommented:
Or you can use a Linq query to get the results as follows.

' Get the table from the DataGridView
Dim table As DataTable = DataGridView1.DataSource
' To Sum the column you can use a Linq query
' In this part of the query, t.Field(Of Integer), change Integer to thecorrect data type for the column to be Sum'ed
' In this part of the query, ("ColumnName"), Change the ColumnName to the name of the column being Sum'ed.
' The variable results will contain the total
Dim results = (From t In table.AsEnumerable()
               Select t.Field(Of Integer)("ColumnName")).Sum(Function(t) t)

Open in new window

SAMIR BHOGAYTAFreelancer and IT ConsultantCommented:
hi..try this way..
decimal a=0, b=0, c=0;
for (int i = 0; i < (gridview1.Rows.Count); i++)  
               a = Convert.ToDecimal(gridview1.Rows.Cells["Column Index"].Text.ToString());
               c = c + a; //storing total qty into variable


Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now