i want to total the values in column9 in Patientdatagridview to a textbox1.
here is my code but it displayes each value, not the total.
e.g. if values are 200, 200, 200 then it should display 600
but here it says 0200200200

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim tot As String = 0
        For i As Integer = 0 To PatientDetailsDataGridView.RowCount - 1
                       tot += PatientDetailsDataGridView.Rows(i).Cells(8).Value
        If tot = 0 Then
            MessageBox.Show("No Records Found")
        End If
        TextBox1.Text = tot.ToString()

    End Sub

Recommended Answers

All 3 Replies

"+" Charactor always concatinates two string type values i.e "200" +"200" always give you the result 200200 instead of 400, because you treat them as string type. If you declare them as numeric type then it will give you 400.

Your mistake is at line no 2. Declare tot as double type instead of string type.

Dim tot As Double = 0#

and the loop should be

For i As Integer = 0 To PatientDetailsDataGridView.RowCount - 1
    tot += Val(PatientDetailsDataGridView.Rows(i).Cells(8).Value)

Hope it should help you.

Yes, I got. Thanks

this one good it help me out thnks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.