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.

i think line 13 should be

cmd.commandText = strCommandText & Values

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.