Export (0) Print
Expand All

SqlCommand.Transaction Property

Gets or sets the SqlTransaction within which the SqlCommand executes.

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

'Declaration
Public Property Transaction As SqlTransaction
'Usage
Dim instance As SqlCommand
Dim value As SqlTransaction

value = instance.Transaction

instance.Transaction = value
/** @property */
public SqlTransaction get_Transaction ()

/** @property */
public void set_Transaction (SqlTransaction value)

public function get Transaction () : SqlTransaction

public function set Transaction (value : SqlTransaction)

Not applicable.

Property Value

The SqlTransaction. The default value is a null reference (Nothing in Visual Basic).

You cannot set the Transaction property if it is already set to a specific value, and the command is in the process of executing. If you set the transaction property to a SqlTransaction object that is not connected to the same SqlConnection as the SqlCommand object, an exception is thrown the next time that you attempt to execute a statement.

Windows 98, Windows Server 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 2.0, 1.0

Community Additions

ADD
Show:
© 2014 Microsoft