I have a problem with my project ! vb.net

Question

1.00/5 (1 vote)

See more:

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
MY PROJECT LINK:
<<link removed>>

----CODE-----

VB

Public Class Form2

    Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the DatabDataSet.tabel2 table. You can move, or remove it, as needed.
        Me.Tabel2TableAdapter.Fill(Me.DatabDataSet.tabel2)

    End Sub

    Private Sub COPY(ByVal source As DataGridView, ByVal des As DataGridView)
        For Each rows In source.SelectedRows
            Dim cell As DataGridViewCellCollection = rows.cells
            Dim row As String() = New String() {cell(0).Value, cell(1).Value, cell(2).Value}
            des.Rows.Add(row)
        Next
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        COPY(DataGridView1, Form1.DataGridView1)
        Me.Hide()
    End Sub
End Class

What I have tried:

When I create columns without data its working but when I try the data with access this problem show

Posted 8-Mar-16 3:35am

ionMEMBER

Updated 8-Mar-16 3:52am

Andy Lanng

v4

Add a Solution

Comments

Andy Lanng 8-Mar-16 9:47am

Please don't link to un-certified files. We discourage such linking to keep the minority of dangerous files away from the unwitting majority.

Your description should be enough. If it isn't then amend the post

Thanks ^_^

ionMEMBER 8-Mar-16 15:45pm

Table on access is with 2 columns: "ID and Description". Whats the right code to copy the value from DataGridview1 to DataGridview2 ?

CHill60 8-Mar-16 9:49am

On which line does the error occur?

Andy Lanng 8-Mar-16 9:52am

I guessed the line with 'cell(2).Value'

CHill60 8-Mar-16 10:07am

So did I ... was just making a point :)

ZurdoDev 8-Mar-16 9:52am

Look at the line of code where the error occurs. Probably the one where you reference cell(2).Value for example. cell(2) or whatever is invalid.

Just debug and you'll see.

ionMEMBER 9-Mar-16 11:50am

Table on access is with 2 columns: "ID and Description". Whats the right code to copy the value from DataGridview1 to DataGridview2 ?

ZurdoDev 9-Mar-16 11:51am

If there are only 2 columns then cell(0) will work and cell(1) will work but cell(2) will not work. Right?

ionMEMBER 9-Mar-16 11:57am

Right but if I delete cell(2), I read this next problem:
des.Rows.Add(row) ---> Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound.

ionMEMBER 8-Mar-16 12:20pm

Table on access is with 2 columns: "ID and Description". Whats the right code to copy the value from DataGridview1 to DataGridview2 ?

Sascha Lefèvre 8-Mar-16 13:53pm

You replied to your own question, not to a comment, so nobody got notified of your comment ;) Use the dim "Reply"-button at the top of a comment to reply to that comment.

Please take a look at my solution (2) where I explained how you can create the code to copy a variable amount of cells.

2 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)

Sascha Lefèvre · Answer 1 · 2016-03-08T03:52:00

The only place you use indices in this code is this line:

VB

Dim row As String() = New String() {cell(0).Value, cell(1).Value, cell(2).Value}

So there's no other possible reason for your error that there aren't three cells in one row. Maybe it's just two or one (or even none). If you intended that there always be exactly three cells then your source DataGridView wasn't correctly constructed and you have to check the code there. Otherwise you should modify your code here to be able to deal with a variable amount of cells, by using a for-loop to copy over the values into an array which you 'dim' with the cell-count beforehand.

Andy Lanng · Answer 2 · 2016-03-08T03:52:00

The hard-coded reference must be the problem:

VB

Dim row As String() = New String() {cell(0).Value, cell(1).Value, cell(2).Value}

You need to know how to handle errors. Either go through each item in a for[each] loop or check the the cell array contains that many items.

You will find that cell array is either empty or has fewer than 3 items.

Calling cell(2) when cell.Length is less than 3 will throw that error

I have a problem with my project ! vb.net

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0