The database is called Pipelining and within that there is a table called questions
There is no error that is coming up, but the information isn't going into the database. I was wondering if anyone would be able to help me with this and see if they can see why its not doing it?
I have breakpointed it and stepped through it but I am unable to see whats going on
Thank you for your time
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click Dim Cmd As OleDbCommand Dim SQL As String Dim objCmd As OleDbCommand Dim Con = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=pipelining.mdb;Persist Security Info=False") Dim question As String = txtQuestion.Text Dim answer1 As String = txtAnswer1.Text Dim answer2 As String = txtAnswer2.Text Dim answer3 As String = txtAnswer3.Text Dim answer4 As String = txtAnswer4.Text Dim answer5 As String = txtAnswer5.Text Dim correctAnswer As String = txtCorrectAnswer1.Text Dim correctAnswer2 As String = txtCorrectAnswer2.Text SQL = "INSERT INTO questions VALUES ('" & question & "', '" & answer1 & "', '" & answer2 & "', '" & answer3 & "', '" & answer4 & "', '" & answer5 & "', '" & correctAnswer & "', '" & correctAnswer2 & "')" Cmd = New OleDbCommand(SQL, Con) Con.Open() objCmd = New OleDbCommand(SQL, Con) objCmd.ExecuteNonQuery() Con.Close() MessageBox.Show("Data Added") formalQuiz.Show() Me.Hide() End Sub