Inserting into Access table 1

[boatdrinks]

I have this code that runs, but nothing shows up in the access table. What am I doing wrong?

Dim connectionString As String =("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & server.mappath("SupportRequests.mdb"))

Dim oleConnection As New OleDBConnection(connectionString)
oleConnection.Open()

Dim oleCommand = New OleDbCommand("INSERT INTO requests(firstname,lastname,importance,problem,software,hardware) Values('" & Insertfirstname.text & "','" & Insertlastname.text & "','" & Insertimportance.selecteditem.text & "','" & Insertproblem.text & "','" & Insertsoftware.selecteditem.text & "','" & Inserthardware.selecteditem.text & "')")

oleCommand.Connection = oleConnection
oleConnection.Close()

 

[DaZZleD]

before oleConnection.Close add oleCommand.ExecuteNonQuery()

--------------------------
"two wrongs don't make a right, but three lefts do" - the unknown sage