SqlCommand.Connection Properti

Definisi

Ruang nama:

System.Data.SqlClient

Rakitan:

System.Data.SqlClient.dll

Paket:

System.Data.SqlClient v4.8.6

Mendapatkan atau mengatur yang SqlConnection digunakan oleh instans ini dari SqlCommand.

public:
 property System::Data::SqlClient::SqlConnection ^ Connection { System::Data::SqlClient::SqlConnection ^ get(); void set(System::Data::SqlClient::SqlConnection ^ value); };

public System.Data.SqlClient.SqlConnection Connection { get; set; }

member this.Connection : System.Data.SqlClient.SqlConnection with get, set

Public Property Connection As SqlConnection

Nilai Properti

SqlConnection

Koneksi ke sumber data. Nilai defaultnya adalah null.

Pengecualian

InvalidOperationException

Properti Connection diubah saat perintah terdaftar dalam transaksi.

Contoh

Contoh berikut membuat SqlCommand dan mengatur beberapa propertinya.

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

Keterangan

Jika perintah terdaftar dalam transaksi yang ada, dan koneksi diubah, mencoba menjalankan perintah akan melemparkan InvalidOperationException.

Transaction Jika properti tidak null dan transaksi telah diterapkan atau digulung balik, Transaction diatur ke null.

Lihat juga

• CommandText
• CommandTimeout
• CommandType
• Ringkasan ADO.NET