How to edit an information using the cell clink in datagridview

Question

0.00/5 (No votes)

See more:

Can you guys help me? When I double click the cell row in datagridview to edit the information, the error shows it says that :

"System.ArgumentOutOfRangeException: 'Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index'
"

ACC_REG is the name of the windowform where they can their information. I'm using VB.NET and MS ACCESS DATABASE

I hope you can help me. Please do respect my question, Thankyou.

What I have tried:

Private Sub DataGridView1_CellClick(sender As Object, e As DataGridViewCellEventArgs) Handles DataGridView1.CellClick
       With ACC_REG
           .storeCode.Text = DataGridView1.CurrentRow.Cells(0).Value
           .usr1.Text = DataGridView1.CurrentRow.Cells(1).Value
           .password1.Text = DataGridView1.CurrentRow.Cells(2).Value
           .storeName.Text = DataGridView1.CurrentRow.Cells(3).Value

           Dim bytes As [Byte]() = DataGridView1.CurrentRow.Cells(4).Value
           Dim ms As New MemoryStream(bytes)
           .PictureBox1.Image = Image.FromStream(ms)
           .addbtn.Enabled = False
           .storeCode.ReadOnly = True
           .ShowDialog()


       End With
   End Sub

Posted 7-Nov-22 2:23am

Hazel Ann Torno 2022

Updated 7-Nov-22 2:28am

Add a Solution

1 solution

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)

Richard Deeming · Answer 1 · 2022-11-07T02:28:00

Solution 1

You didn't tell us which line the error occurs on, but the error message suggests that the CurrentRow doesn't have at least five cells.

You'll need to debug your code and step through the method to find out how many cells it does have. Then work out why it doesn't have as many cells as you expect.

We can't do that for you, since we have no access to your computer.

Posted 7-Nov-22 2:28am

Richard Deeming

Comments

Hazel Ann Torno 2022 7-Nov-22 10:02am

HI! THIS LINE ERROR OCCURS 'Dim bytes As [Byte]() = DataGridView1.CurrentRow.Cells(4).Value' Can you tell me what's wrong with that?

Richard Deeming 7-Nov-22 10:04am

As I said, the CurrentRow doesn't contain at least five cells. If the error occurs when you try to access .Cells(4), then it only contains four cells, with indexes from 0 to 3.

You need to debug your code to find out why. We can't do that for you.