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


            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

                Next i
                cmd = Nothing

            End If


        Catch ex As Exception
        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.