Loading

How to delete all the empty rows in a datagirdview?

Ako Musha

8y727

I would like to delete the empty rows from a column. Here is what I've tried but does not work, I am getting an error as "use 'new' keyword to create an object instance"!

Your help would be appreciated, thanks so much.

For i= data.Rows.Count - 1 To 0 Step -1
Dim row As DataGridViewRow = data.Rows(i)
if (Not row.IsNewRow Andalso data.Rows(i).Cells(1).Value.Tostring() = "") Then
data.Rows.RemoveAt(i)
Else
End If

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ako Musha8y ago
Thanks Suraj, I was able to get it work using different approach...
For i= data.Rows.Count - 1 To 0 Step -1
If String.IsNullOrEmpty(row.cell(1).Value) Then
data.Rows.RemoveAt(i)

End If
0
Ako Musha8y ago
Thanks, but still getting the same message. how can I check to see if these cell values are or are not actually Null?
0
Suraj Kumar8y ago
try the below code
For i As Integer = 1 To dataGridView1.RowCount - 1 - 1

    If dataGridView1.Rows(i).Cells(0).Value.ToString() = "" OrElse dataGridView1.Rows(i).Cells(1).Value.ToString() = "" Then
        dataGridView1.Rows.RemoveAt(i)
        i -= 1
    End If
Next
Hope this will help you
0