The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

SqlCommand Constructor (String^, SqlConnection^)

.NET Framework (current version)

Other Versions

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

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

Syntax

C++

public:
SqlCommand(
	String^ cmdText,
	SqlConnection^ connection
)

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.

Remarks

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.

Examples

The following example creates a SqlCommand and sets some of its properties.

C++

No code example is currently available or this language may not be supported.

Version Information

.NET Framework
Available since 1.1

Deutsch	English	Español	Français
Italiano	日本語	한국어	Português
Pусский	简体中文	繁體中文