SqlCommand.Connection SqlCommand.Connection SqlCommand.Connection SqlCommand.Connection Property

定義

この SqlCommand のインスタンスで使用する SqlConnection を取得または設定します。Gets or sets the SqlConnection used by this instance of the SqlCommand.

public:
 property System::Data::SqlClient::SqlConnection ^ Connection { System::Data::SqlClient::SqlConnection ^ get(); void set(System::Data::SqlClient::SqlConnection ^ value); };
[System.Data.DataSysDescription("DbCommand_Connection")]
public System.Data.SqlClient.SqlConnection Connection { get; set; }
member this.Connection : System.Data.SqlClient.SqlConnection with get, set
Public Property Connection As SqlConnection

プロパティ値

データ ソースへの接続。The connection to a data source. 既定値は null です。The default value is null.

例外

コマンドがトランザクションに登録されていた間に、Connection プロパティが変更されました。The Connection property was changed while the command was enlisted in a transaction.

次の例では、作成、SqlCommandおよび一部のプロパティを設定します。The following example creates a SqlCommand and sets some of its properties.

private static void CreateCommand(string queryString,
    string connectionString)
{
    using (SqlConnection connection = new SqlConnection(
               connectionString))
    {
        SqlCommand command = new SqlCommand();
        command.Connection = connection;
        command.CommandTimeout = 15;
        command.CommandType = CommandType.Text;
        command.CommandText = queryString;

        connection.Open();
        SqlDataReader reader = command.ExecuteReader();
        while (reader.Read())
        {
            Console.WriteLine(String.Format("{0}, {1}",
                reader[0], reader[1]));
        }
    }
}
Public Sub CreateCommand(ByVal queryString As String, _
  ByVal connectionString As String)
    Using connection As New SqlConnection(connectionString)
        Dim command As New SqlCommand()
        command.Connection = connection
        command.CommandTimeout = 15
        command.CommandType = CommandType.Text
        command.CommandText = queryString

        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

注釈

コマンドは、既存のトランザクションに参加して、接続が変更された場合がスローされます、コマンドを実行しようとして、InvalidOperationExceptionします。If the command is enlisted in an existing transaction, and the connection is changed, trying to execute the command will throw an InvalidOperationException.

Transaction プロパティが NULL でない場合、トランザクションが既にコミット済みまたはロールバック済みであれば、Transaction は NULL に設定されます。If the Transaction property is not null and the transaction has already been committed or rolled back, Transaction is set to null.

適用対象

こちらもご覧ください