SqlCommand Constructor (String, SqlConnection)

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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)

Public Sub New (
	cmdText As String,
	connection As SqlConnection
)

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.

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.

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

Public Sub CreateCommand(ByVal queryString As String, _
  ByVal connectionString As String)
    Using connection As New SqlConnection(connectionString)
        Dim command As New SqlCommand(queryString, connection)

        connection.Open()
        Dim reader As SqlDataReader = command.ExecuteReader()
            While reader.Read()
            Console.WriteLine(String.Format("{0}, {1}", _
                reader(0), reader(1)))
        End While
    End Using
End Sub

.NET Framework
Available since 1.1
Return to top
Show: