out of range exception

Question

0.00/5 (No votes)

See more:

I get an out of range error here

VB

Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
        Dim i As New Integer
        i = 0
        For i = 0 To DataGridView1.RowCount - 1
         If DataGridView1.Rows(i).Cells(0).Value.ToString() = "" Then 'here error
         DataGridView1.Rows.RemoveAt(i)
            End If
        Next

any help? strange error I have put the -1

Posted 3-Jun-14 20:12pm

Member 3892343

Updated 3-Jun-14 21:02pm

v3

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-06-03T20:18:00

Um.
Think about it go a moment.
You have, say, 3 items on your data grid view.
So you will go round the loop 3 times, with i set to 0, 1, and 2.
But... After you have processed the item at index 0, you remove it. So the next time round, you process the item at index 1, which used to be at index 2, then delete it. What item are you going to process next?

Either go down through the indexes instead of up, or use Clear after the loop to remove all the items.

Karthik_Mahalingam · Answer 2 · 2014-06-03T20:20:00

Solution 3

Try this

VB

If DataGridView1.Rows(i).Cells(0).Value + "" = "" Then 
DataGridView1.Rows.RemoveAt(i)

Posted 3-Jun-14 20:20pm

Karthik_Mahalingam

Mehdi Gholam · Answer 3 · 2014-06-03T20:20:00

If you remove rows then the RowCount will change and you will get an out of range exception.

You should gather what you want to remove first in a loop then remove them afterwards.

VB

Dim toremove As New List(Of Integer)

For i = 0 To DataGridView1.RowCount - 1
  If DataGridView1.Rows(i).Cells(0).Value.ToString() = "" Then
     toremove.Add(i)
  End If
Next

For each i as Integer in toremove
  DataGridView1.Rows.RemoveAt(i)

ArunRajendra · Answer 4 · 2014-06-03T20:24:00

I guess the problem is due to Remove.

This is my understanding might be I am wrong. If you have two rows then count will be 2. So the first record is removed now the second is moved to first position i.e. from 1 to 0. Now "i" is 1 but there is only record in the collection and it is at index 0.

Solution: Start the loop from last row to first i.e. Rowcount -1 to 0.

Jide X · Answer 5 · 2014-06-03T20:18:00

Solution 2

Either Rows or Cells may not have items defined in them. Put a break point and debug. You will know for sure why this error is coming up.

Posted 3-Jun-14 20:18pm

Jide X

out of range exception

5 solutions

Solution 1

Solution 3

Solution 4

Solution 5

Solution 2

Add your solution here

Preview 0