This documentation is archived and is not being maintained.

SqlRowsCopiedEventArgs.Abort Property

Gets or sets a value that indicates whether the bulk copy operation should be aborted.

Namespace:  System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

public bool Abort { get; set; }

Property Value

Type: System.Boolean
true if the bulk copy operation should be aborted; otherwise false.

Use the Abort property to cancel a bulk copy operation. Set Abort to true to abort the bulk copy operation.

If you call the Close method from SqlRowsCopied, an exception is generated, and the SqlBulkCopy object state does not change.

If an application specifically creates a SqlTransaction object in the SqlCommand constructor, the transaction is not rolled back. The application is responsible for determining whether it is required to rollback the operation, and if so, it must call the SqlTransaction.Rollback method. If the application does not create a transaction, the internal transaction corresponding to the current batch is automatically rolled back. However, changes related to previous batches within the bulk copy operation are retained, because the transactions for them already have been committed.

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5, 3.0, 2.0
Show: