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

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

Thanks, but still getting the same message. how can I check to see if these cell values are or are not actually Null?

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

Answers

How to delete all the empty rows in a datagirdview?

Ako Musha

500

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.