How to remove empty or blank row in DataGridView

[hhm_pro992]

Hi!
I want to know, how to delete empty or blank row in DataGridView in Vb.net..........
"When i click Button the all empty or blank row in DataGridView will be remove......"
LIKE this :
" Before Button Clicked "

" After Button Clicked "

[Reverend Jim]

Try

For r As Integer = dgvMyGrid.Rows.Count - 1 To 0 Step -1

    Dim empty As Boolean = True

    For Each cell As DataGridViewCell In dgvMyGrid.Rows(r).Cells
        If Not IsNothing(cell.Value) Then
            empty = False
            Exit For
        End If
    Next

    If empty Then dgvMyGrid.Rows.RemoveAt(r)

Next

You want to delete from the bottom to the top because if you delete from the top first then you end up changing the number of rows while the loop is executing.

[OtepTheThird]

As i can see here, you are directly adding/editing on your datagridview, right?, are you using Access, MySQL or SQL?

[Reverend Jim]

For all we know the OP could be using an unsourced DataGridView. Judging by the last picture I would imagine that AllowUserToAddRows is set to False otherwise there would be a blank (uncommitted) row displayed after the two records.

[hhm_pro992]

You r GREAT..................Thanks Again "REVEREND JIM"