Export (0) Print
Expand All

SqlCommand Constructor (String, SqlConnection, SqlTransaction)

Initializes a new instance of the SqlCommand class with the text of the query, a SqlConnection, and the SqlTransaction.

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

public SqlCommand(
	string cmdText,
	SqlConnection connection,
	SqlTransaction transaction
)

Parameters

cmdText
Type: System.String

The text of the query.

connection
Type: System.Data.SqlClient.SqlConnection

A SqlConnection that represents the connection to an instance of SQL Server.

transaction
Type: System.Data.SqlClient.SqlTransaction

The SqlTransaction in which the SqlCommand executes.

The following table shows initial property values for an instance of SqlCommand.

Properties

Initial value

CommandText

cmdText

CommandTimeout

30

CommandType

CommandType.Text

Connection

A new SqlConnection that is the value for the connection parameter.

You can change the value for any of these parameters by setting the related property.

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1
Show:
© 2015 Microsoft