Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SqlCommand Constructor (String)

SqlCommand Constructor (String)

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

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

new : 
        cmdText:string -> SqlCommand

Parameters

cmdText
Type: System.String

The text of the query.

When an instance of SqlCommand is created, the following read/write properties are set to initial values.

Properties

Initial value

CommandText

cmdText

CommandTimeout

30

CommandType

CommandType.Text

Connection

null

You can change the value for any of these properties through a separate call to the property.

The following example creates a SqlCommand, passing in the connection string and command text.

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

.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