jdy0803
Well-known member
Here is my code.
cmd = New OleDbCommand()
cmd.Connection = cn
Sql = "INSERT INTO provider_schedule (provider_id, day, open_yn, start1, end1) VALUES ( '1', '" & ListView1.Items(i).Text.Trim & _
"', '" & ListView1.Items(i).SubItems(1).Text.Trim & "', '" & ListView1.Items(i).SubItems(2).Text.Trim & "', '" & ListView1.Items(i).SubItems(3).Text.Trim & "' )"
cmd = New OleDbCommand(Sql, cn)
records = cmd.ExecuteNonQuery()
cmd.Dispose()
Following error occurs at cmd.ExecuteNonQuery
Syntax error in INSERT INTO Statement
If I display Sql, it's like this.
INSERT INTO provider_schedule (provider_id, day, open_yn, start1, end1) VALUES ('1','2','1','1/1/2000 9:00:00 AM', '1/1/2000 9:00:00 PM')
Can anybody give me help?
cmd = New OleDbCommand()
cmd.Connection = cn
Sql = "INSERT INTO provider_schedule (provider_id, day, open_yn, start1, end1) VALUES ( '1', '" & ListView1.Items(i).Text.Trim & _
"', '" & ListView1.Items(i).SubItems(1).Text.Trim & "', '" & ListView1.Items(i).SubItems(2).Text.Trim & "', '" & ListView1.Items(i).SubItems(3).Text.Trim & "' )"
cmd = New OleDbCommand(Sql, cn)
records = cmd.ExecuteNonQuery()
cmd.Dispose()
Following error occurs at cmd.ExecuteNonQuery
Syntax error in INSERT INTO Statement
If I display Sql, it's like this.
INSERT INTO provider_schedule (provider_id, day, open_yn, start1, end1) VALUES ('1','2','1','1/1/2000 9:00:00 AM', '1/1/2000 9:00:00 PM')
Can anybody give me help?
Last edited: