I am using visual studio 2008 nd ms access...i am getting the error in my insert command i have modified the database table also but still i am getting the same error.plz help me..
Private Sub btninsert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btninsert.Click
con.Open()
cmd = New OleDbCommand("insert into b1 values( " & TextBox1.Text & " , ' " & TextBox2.Text & " ' , ' " & TextBox3.Text & " ' , ' " & TextBox4.Text & " ' , " & TextBox5.Text & " , ' " & TextBox6.Text & " ' , " & TextBox7.Text & " , " & TextBox8.Text & " , ' " & TextBox9.Text & " ' , " & TextBox10.Text & " , " & TextBox11.Text & " , ' " & TextBox12.Text & " ' , " & TextBox13.Text & " , " & TextBox14.Text & " , " & TextBox15.Text & " , " & TextBox16.Text & " , " & TextBox17.Text & " )", con)
cmd.ExecuteNonQuery()
MsgBox("INSERTED")
con.Close()