VB.NET - How To Get The Sum Of All DataGridView Column Values In VB NET
In This VB.NET Tutorial We Will See How To Get The Sum Of All Values From Specific DataGridView Column And Display It In TextBox Using VBNET Programming Language.
Project Source Code:
Public Class VB_Datagridview_Column_Cells_Values_Sum
Private Sub VB_Datagridview_Column_Cells_Values_Sum_Load(sender As Object, e As EventArgs) Handles MyBase.Load
' populate datagridview with some data
Dim rand As New Random()
For i As Integer = 0 To 11 Step +1
dataGridView1.Rows.Add("First Name" + i.ToString(), "Last Name" + i.ToString(), rand.Next(20, 65).ToString())
Next
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill
dataGridView1.AllowUserToAddRows = False
' Method 1
textBoxSum.Text = (From row As DataGridViewRow In dataGridView1.Rows
Where row.Cells(2).FormattedValue.ToString() <> String.Empty
Select Convert.ToInt32(row.Cells(2).FormattedValue)).Sum().ToString()
' Method 2
Dim sum As Integer = 0
For i As Integer = 0 To dataGridView1.Rows.Count() - 1 Step +1
sum = sum + dataGridView1.Rows(i).Cells(2).Value
Next
textBoxSum.Text = sum.ToString()
End Sub
End Class
///////////////OUTPUT:
 |
| vb.net datagridview column get sum values |
Download Projects Source Code
1 comments:
commentsamateur de vb.net :
Replymerci beaucoup.....