I followed the suggestion from http://www.daniweb.com/software-development/vbnet/threads/388317 this thread. however i face a bit of a problem

in my case i have a combobox at row(i).cells(0)

the code seems to take the last new rows where there's not record and shows error

the debug error msg is

A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll
INSERT into taken(typeID,quantity) VALUES (5,39)
INSERT into taken(typeID,quantity) VALUES (,)

here the typeID is listed in combo derived from database table.
my code is

Try
            con.Open()

            If DataGridView1.Rows.Count > 0 Then

                Dim cmd As New OleDbCommand
                cmd.Connection = con
                cmd.CommandType = Data.CommandType.Text
                Dim strcommandText As String = "INSERT into taken(typeID,quantity) VALUES ("
                Dim values As String = ""
                For i As Integer = 0 To DataGridView1.Rows.Count - 1
                    values = strcommandText & DataGridView1.Rows(i).Cells(0).Value & "," & DataGridView1.Rows(i).Cells(2).Value & ")"
                    cmd.CommandText = values
                    Debug.Print(cmd.CommandText)
                    cmd.ExecuteNonQuery()


                Next i
                cmd = Nothing


            End If

            con.Close()
            MsgBox("Success")

        Catch ex As Exception
            MsgBox(ex.ToString)
        Finally
            
        End Try

i was hoping For i As Integer = 0 To DataGridView1.Rows.Count - 1 to solve this problem but it doesn't. don't know how to fix this, please help.

This article has been dead for over six months. Start a new discussion instead.