Hello,
I'm new in vb.net. I have a problem in inserting a new row to a MS Access database table.
There is no error message comes out when i run my program, but when i check my MS Access table,
there is no record inserted. So, i don't know which line is incorrect.

Here is my code:

        Dim desc, itemID As String

        itemID = txtItemID.Text
        desc = txtItemDesc.Text

        Dim myOleDbConnection As OleDb.OleDbConnection
        Dim insertCommand As String
        Dim myConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=E:\Lecture\CS220\Program backup 3\Ai Ling Ka Salon System\database\login.mdb;User
ID=Admin;Password=;"

        insertCommand = "INSERT INTO tblLogin (username, password) VALUES(desc, itemID);"

        myOleDbConnection = New OleDb.OleDbConnection(myConnectionString)

        Dim myOleDbCommand As New OleDb.OleDbCommand(insertCommand, myOleDbConnection)

        myOleDbCommand = myOleDbConnection.CreateCommand

        myOleDbCommand.CommandType = CommandType.Text

        myOleDbCommand.CommandText = insertCommand

        myOleDbConnection.Open()

        Dim temp_num As Integer
        Try
            temp_num = myOleDbCommand.ExecuteNonQuery
        Catch ex As Exception
            Trace.WriteLine(ex.ToString)

        End Try

        myOleDbConnection.Close()