Hi All, could you help, summary the data in DGview1 to DGview2. here's my table.
Name Hours
Name1 1
Name1 1
Name1 2
Name1 3
Name1 1
Name2 3
Name2 3
Name2 3
Expected output:
Name Hours
Name1 8
Name2 9
What I have tried:
I used, for loop on the first but not the expected output.
For util As Integer = 0 To DataGridView1.RowCount - 2
If DataGridView1.Rows(util).Cells(0).Value = "Name1" Then
Dim totalUtil As Double
totalUtil += Convert.ToDecimal(DataGridView1.Rows(util).Cells(5).Value)
DataGridView4.Rows.Add(DataGridView1.Rows(util).Cells(0).Value, totalUtil)
End If
Next
Output:
Name Hours
Name1 1
Name1 2
Name1 5
Name1 11
Name1 so on..
Name2 so on..