vb.net中的SQL transaction语句

Using connection As New SqlConnection(connectionString)
    connection.Open()

    ' 开始事务
    Dim transaction As SqlTransaction = connection.BeginTransaction()

    Try
        ' 执行数据库操作
        Dim command As New SqlCommand()
        command.Connection = connection
        command.Transaction = transaction
        command.CommandText = "INSERT INTO TableName (Column1, Column2) VALUES (@Value1, @Value2)"
        command.Parameters.AddWithValue("@Value1", value1)
        command.Parameters.AddWithValue("@Value2", value2)
        command.ExecuteNonQuery()

        ' 提交事务
        transaction.Commit()

        Console.WriteLine("事务已提交")
    Catch ex As Exception
        ' 回滚事务
        transaction.Rollback()

        Console.WriteLine("事务已回滚")
    End Try
End Using