[RESOLVED] Rowcount particular value

[feroguz]

Hi vbforum users!

I need to rowcount in datagridview with a particular value.
My column "6" have the value that find, I try with the following code:

  Dim apc As Decimal = 0
For x As Integer = 0 To DataGridView3.RowCount - 1
            If DataGridView3.Rows(x).Cells(6).Value = "AP" Then
                apc = DataGridView3.Rows(x).Cells(6).Value.ToString.Count
            End If

        Next
textbox1.text=apc

any help, as welcome!!
Best Regards!!

[dolot]

Are you trying to get the sum of the values in column 6, or just the count of the number of rows that have the given value?

If the former, then the line above would look like:

apc += DataGridView3.Rows(x).Cells(6).Value

If the latter, then you would simply say:

apc += 1

[feroguz]

Great Dolot! Best Regards!

 For x = 0 To DataGridView3.Rows.Count - 1
            If DataGridView3.Rows(x).Cells(6).Value = "AP" Then
                count += 1
            End If
        Next

[dolot]

How exactly is the datagridview being populated? Is there a datatable attached to it, or is it just user input?

[feroguz]

Hi Sr!

Only populate the textbox

 For x = 0 To DataGridView3.Rows.Count - 1
            If DataGridView3.Rows(x).Cells(6).Value = "AP" Then
                count += 1
            End If
        Next
textbox1.text=count