title: Syntax error in INSERT INTO statement. OledbException was unhandled... did everything i saw here in stack but nothing seems to work
body: <pre><code>Dim cmd As New OleDbCommand
  OpenConnection()
  cmd.Connection = con
  cmd.CommandText = "INSERT INTO [StudentInfo] ([Stud_Num], [Stud_FName], [Stud_LName], [Stud_ContactNum], [Stud_Email], [Stud_Address], [Stud_Username], [Stud_Password], [Stud_ConfirmPassword]) VALUES (" &amp; _
                    txtStudNum.Text &amp; ", '" &amp; txtFname.Text &amp; "', '" &amp; txtLname.Text &amp; "', '" &amp; _
                    txtNum.Text &amp; "', '" &amp; txtEmail.Text &amp; "', '" &amp; txtAddress.Text &amp; "' , '" &amp; txtUsername.Text &amp; "', '" &amp; txtPassword.Text &amp; "', '" &amp; txtConPassword.Text &amp; "')"
  cmd.ExecuteNonQuery()
  </code></pre>
  
  <p>The error was the <code>cmd.ExecuteNonQuery()</code> I'm still a student and a noob in using vb.net so please could you tell me what I did wrong ?</p>