Solved

# Calculating column datagridview

Posted on 2014-02-17
512 Views
Hello,

How do you calculate an entire column in a datagridview in vb.net ?
0
Question by:lincstech
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 40

Accepted Solution

Jacques Bourgeois (James Burger) earned 250 total points
ID: 39865184
Dim total As Integer
For x As Integer = 0 To DataGridView1.Rows.Count - 1
total += CInt(DataGridView1.Item(3, x).Value)
Next

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.
0

LVL 63

Assisted Solution

Fernando Soto earned 250 total points
ID: 39865319
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)
``````
0

LVL 11

Expert Comment

ID: 39869750
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

}
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question