จะ Insert 2 ตารางโดยนำค่า ID จาก Auto Increment ล่าสุดมาใช้น่ะครับ (VB.Net)

 '*** Query 3 ***'
            strSQL = "INSERT INTO bill (billID,table_no,bill_total_price,date,time)VALUES('','" & lblTableNo.Text & "','" & lblTotalPrice.Text & "','" & lblDate.Text & "','" & lblTime.Text & "' )"
            objCmd = New MySql.Data.MySqlClient.MySqlCommand()
            With objCmd
                .Connection = objConn
                .Transaction = Trans
                .CommandType = CommandType.Text
                .CommandText = strSQL
            End With
            objCmd.ExecuteNonQuery()

'*** Query 4 ***'
            For i = 0 To lvPayment.Items.Count - 1
                strSQL = "INSERT INTO bill_detail (bill_detailID,billID,product_name,item,product_total_price) VALUES('','" & lblฺBillID.Text & "', " & lvPayment.Items(i).SubItems(0).Text & "', '" & lvPayment.Items(i).SubItems(1).Text & "','" & lvPayment.Items(i).SubItems(2).Text & "')"
                objCmd = New MySql.Data.MySqlClient.MySqlCommand()
                With objCmd
                    .Connection = objConn
                    .Transaction = Trans
                    .CommandType = CommandType.Text
                    .CommandText = strSQL
                End With
                objCmd.ExecuteNonQuery()
            Next