I want to add data to a table in a data base. this code have error in insert into statement. please solve this to me. thank you. [ujnimz]
Dim con As OleDbConnection
Dim com As OleDbCommand
Dim NAME As String
Try
con = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\NIMANTHA\Documents\DONUJ.accdb")
com = New OleDbCommand("INSERT INTO STUDENTS (StudentID, StudentName, Grade,TeacherIncharge)VALUES (@STID,@NAME,@GRADE,@TEACHER))", con)
con.Open()
MsgBox("DATABASE IS OPEN NOW")
com.Parameters.AddWithValue("@STID", TextBox1.Text)
com.Parameters.AddWithValue("@NAME", TextBox2.Text)
com.Parameters.AddWithValue("@GRADE", TextBox3.Text)
com.Parameters.AddWithValue("@TEACHER", TextBox4.Text)
com.ExecuteNonQuery()
NAME = TextBox2.Text
MsgBox("Add " & NAME & "'s status")
con.Close()
Catch ex As Exception
MsgBox(ErrorToString)
End Try
Marked 
