从mysql数据库返回VB.Net中当前插入行的自动递增ID号

Imports System.Data.SqlClient

' 创建mysql数据库连接字符串
Dim connString As String = "Data Source=myServerAddress;Initial Catalog=myDatabase;User ID=myUsername;Password=myPassword"

' 创建mysql数据库连接对象
Using conn As New SqlConnection(connString)
    ' 打开数据库连接
    conn.Open()

    ' 创建插入数据的SQL语句
    Dim sql As String = "INSERT INTO YourTable (Column1, Column2) VALUES (@Value1, @Value2); SELECT LAST_INSERT_ID();"

    ' 创建命令对象
    Using cmd As New SqlCommand(sql, conn)
        ' 添加参数
        cmd.Parameters.AddWithValue("@Value1", "SomeValue1")
        cmd.Parameters.AddWithValue("@Value2", "SomeValue2")

        ' 执行SQL语句并获取自动递增ID号
        Dim id As Integer = Convert.ToInt32(cmd.ExecuteScalar())

        ' 输出自动递增ID号
        Console.WriteLine("自动递增ID号: " & id.ToString())
    End Using

    ' 关闭数据库连接
    conn.Close()
End Using