I am using ms access 2010 database for my vb.net application. when I run the insert into statement it gives me erro in OleDb exeption was unhandled syntax error in INSERT INTO statement. when I run the query in SQL view in ms access it shows the error in
please anyone help me I can't find what is the error/errors.
Code:
"Insert into Enter_Attendence(Course,Subject,Month,Date,Year,Semester,Day/Parttime,Nameofstudent) values('"
'this is my insert into statement.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
cmd = New OleDbCommand("Insert into Enter_Attendence(Course,Subject,Month,Date,Year,Semester,Day/Parttime,Nameofstudent) values('" & ComboBox1.SelectedItem & "','" & ComboBox5.SelectedItem & "','" & ComboBox6.SelectedItem & "',#" & ComboBox7.SelectedItem & "#,'" & ComboBox2.SelectedItem & "','" & ComboBox3.SelectedItem & "','" & ComboBox4.SelectedItem & "','" & CheckedListBox1.CanSelect & "')", con)
cmd.ExecuteNonQuery()
Comment