Connection Property (SqlCommand)

In This Topic

Syntax
Remarks
Example
See Also

Gets or sets the SqlConnection used by this instance of the SqlCommand.

Syntax

Visual Basic
C#

public new SqlConnection Connection {get; set;}

'Declaration
 
Public Shadows Property Connection As SqlConnection

Property Value

The connection to a data source. The default value is a null reference.

Remarks

SqlConnection specified in this property will carry out all operations executed with this SqlCommand.

This property supports the InterForm technology.

A single SqlConnection can be used by many SqlCommand objects on the assumption that all operations will be done consecutively. In other words, you can not execute an SQL statement while an asynchronous operation is in progress.

Example

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

csharp

public void CreateCommand()
{
  string mySelectQuery = "SELECT * FROM Test.Dept ORDER BY DeptNo";
  SqlCommand myCommand = new SqlCommand(mySelectQuery);
  myCommand.Connection = new SqlConnection(
    "User Id=sa;Server=localhost;Initial Catalog=Test;");
  myCommand.CommandType = System.Data.CommandType.Text;
}

Visual Basic

Public Sub CreateCommand()
  Dim mySelectQuery As String = _
    "SELECT * FROM Test.Dept ORDER BY DeptNo"
  Dim myCommand As New SqlCommand(mySelectQuery)
  myCommand.Connection = New SqlConnection( _
    "User Id=sa;Server=localhost;Initial Catalog=Test;")
  myCommand.CommandType = System.Data.CommandType.Text
End Sub

Reference

SqlCommand Class
SqlCommand Members
CommandText Property
CommandType Property

Send Feedback