remove rows containing string

Question

I would like to know how i can remove these rows insted of making them green

    Private Sub Button3_Click(sender As Object, e As EventArgs) Handles Button3.Click
    'test
    Dim examplea As String = "PAID"
    If DataGridView1.Rows.Count > 0 Then
        For i = 0 To DataGridView1.Rows.Count - 1
            If examplea = DataGridView1.Rows(i).Cells("PROJECT").Value.ToString Then
                ' MessageBox.Show("record already exist")
                DataGridView1.Rows(i).DefaultCellStyle.BackColor = Color.green
                'DataGridView1.Rows.Remove(DataGridView1.CurrentRow)
            Else
                ''MsgBox("N-E")
                'Exit For
            End If
        Next
    End If
    'test
End Sub

`"making them red"` am I missing where this is at in your code? — Trevor, Sep 02 '15 at 15:26
possible duplicate of [Remove row from DataGridView](http://stackoverflow.com/questions/4950205/remove-row-from-datagridview) — Ňɏssa Pøngjǣrdenlarp, Sep 02 '15 at 15:30

score 0 · Answer 1 · answered Sep 02 '15 at 15:29

Not sure I am entirely understanding what you need except you want to remove a row...

Private Sub Button3_Click(sender As Object, e As EventArgs) Handles Button3.Click
    'test
    Dim examplea As String = "PAID"
    If DataGridView1.Rows.Count > 0 Then
       For i = DataGridView1.Rows.Count - 1 To 0 Step -1
            If examplea = DataGridView1.Rows(i).Cells("PROJECT").Value.ToString Then
                ' MessageBox.Show("record already exist")
                'DataGridView1.Rows(i).DefaultCellStyle.BackColor = Color.green
                DataGridView1.Rows.RemoveAt(i)
            Else
                ''MsgBox("N-E")
                'Exit For
            End If
        Next
    End If
    'test
End Sub

well what i need is to remove the row if it says PAID in its project column — LabRat, Sep 02 '15 at 15:32
@ABANDONDACOUNT an important thing to note is that you must iterate backwards in order to evaluate all the rows if you will be removing any — Ňɏssa Pøngjǣrdenlarp, Sep 02 '15 at 15:35

remove rows containing string

1 Answers1