For loop not iterating datagridview data

See more:

VB

When I try to loop through the elements in a datagridview I'm getting an error "This row already belongs in the table". The error occurs at the add new row section of code. I have been struggling with this and cannot seem to find a solution. Could someone help? I'm sure it's just something simple that I am not seeing. Below is the code. Thanks in advance.



SELECT * FROM Testdat
da2 = New MySqlDataAdapter(sql2, conn2)
da2.Fill(ds2)
Dim cb As New MySqlCommandBuilder(da2)
Dim dsNewRow As DataRow
dsNewRow = ds2.Tables(0).NewRow
'Dim View As String
Dim i As Integer = 0
For Each row As DataGridViewRow In DataGridView1.Rows
dsNewRow.Item = DataGridView1.Rows(i).Cells(0).Value
'View = DataGridView1.Rows(i).Cells(0).Value
dsNewRow.Item( = DataGridView1.Rows(i).Cells(1).Value
dsNewRow.Item = DataGridView1.Rows(i).Cells(2).Value
i += 1
ds2.Tables(0).Rows.Add(dsNewRow) (error occurs here)
Next row
da2.Update(ds2.Tables(0))