.net - How can I get the id of a record inserted into mysql database in visual basic?

Question

I am trying to get the Id of the inserted record, because I need to insert data with the generated Id. Help me please.

I′m using visual basic 2008 express edition

This is my code:

        Dim id_header As Integer
        Dim queryHeadReceta As String

        'TRANSACTION IN CASE INSERTS FAIL
        transaction = connection.BeginTransaction()

        cmd.Connection = connection
        cmd.Transaction = transaction

        'GENERATE HEADER ID
        queryHeadReceta = "INSERT INTO tb_receta_enc(cant_despensa, id_usuario) VALUES(@cant_despensa, @id_usuario)"

        Try
            cmd.CommandText = queryHeadReceta.ToString
            cmd.Parameters.Add("@cant_despensa", txt_cant_bolsa.Text)
            cmd.Parameters.Add("id_usuario", 1)
            cmd.ExecuteNonQuery()


           'here I want to get the id to use in new records


            transaction.Commit()

        Catch ex As Exception
            MsgBox(ex.Message)
            transaction.Rollback()
        End Try

question from:https://stackoverflow.com/questions/65925819/how-can-i-get-the-id-of-a-record-inserted-into-mysql-database-in-visual-basic

Answer 1

Waitting for answers