I am using an OleDbConnection.
I would like to get back the auto incremented id from the insert command.
executeSQL("insert into tests (description, offset) values('" & testName & "'," & offsetValue & ")")
Public Function executeSQL(ByVal sqlstring$)
Dim myCommand As New SqlCommand(sqlstring)
Dim myConnection As New OleDb.OleDbConnection(connectionString)
Dim dataCommand As New OleDb.OleDbCommand(sqlstring, myConnection)
retValue = dataCommand.ExecuteNonQuery()