Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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)

'Declaration
Public Sub New ( _
	cmdText As String _
)

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.

Public Sub CreateCommand()
    Dim queryString As String = "SELECT * FROM Categories ORDER BY CategoryID" 
    Dim command As New SqlCommand(queryString)
    command.CommandTimeout = 15
    command.CommandType = CommandType.Text
End Sub

.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