Start New Discussion within our Software Development Community

I followed the suggestion from 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.

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