OleDbConnection.ConnectionTimeout Properti

Definisi

Ruang nama:

System.Data.OleDb

Rakitan:

System.Data.OleDb.dll

Paket:

System.Data.OleDb v9.0.0-preview.5.24306.7

Sumber:

OleDbConnection.cs

Mendapatkan waktu untuk menunggu (dalam detik) saat mencoba membuat koneksi sebelum mengakhiri upaya dan menghasilkan kesalahan.

public:
 virtual property int ConnectionTimeout { int get(); };

public override int ConnectionTimeout { get; }

member this.ConnectionTimeout : int

Public Overrides ReadOnly Property ConnectionTimeout As Integer

Nilai Properti

Int32

Waktu dalam detik untuk menunggu koneksi terbuka. Nilai defaultnya adalah 15 detik.

Penerapan

ConnectionTimeout

Pengecualian

ArgumentException

Nilai yang ditetapkan kurang dari 0.

Contoh

Contoh berikut membuat OleDbConnection dan mengatur beberapa propertinya di string koneksi.

// The connectionString argument contains the Connect Timeout
// keywords, as follows: "... ;Connect Timeout=30;"
public void InsertRow(string connectionString, string insertSQL)
{
    using (OleDbConnection connection = new OleDbConnection(connectionString))
    {
        // The insertSQL string contains a SQL statement that
        // inserts a new row in the source table.
        OleDbCommand command = new OleDbCommand(insertSQL);

        // Set the Connection to the new OleDbConnection.
        command.Connection = connection;

        // Open the connection and execute the insert command.
        try
        {
            connection.Open();
            command.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
        // The connection is automatically closed when the
        // code exits the using block.
    }
}

' The connectionString argument contains the Connect Timeout 
' keywords, as follows: "... ;Connect Timeout=30;"
Public Sub InsertRow(ByVal connectionString As String, _
    ByVal insertSQL As String)

    Using connection As New OleDbConnection(connectionString)
        ' The insertSQL string contains a SQL statement that
        ' inserts a new row in the source table.
        Dim command As New OleDbCommand(insertSQL)

        ' Set the Connection to the new OleDbConnection.
        command.Connection = connection

        ' Open the connection and execute the insert command.
        Try
            connection.Open()
            command.ExecuteNonQuery()
        Catch ex As Exception
            Console.WriteLine(ex.Message)
        End Try
        ' The connection is automatically closed when the
        ' code exits the Using block.
    End Using
End Sub

Keterangan

Nilai 0 menunjukkan tidak ada batasan, dan harus dihindari karena ConnectionString upaya untuk terhubung akan menunggu tanpa batas waktu.

Lihat juga

• Database
• DataSource
• Menyambungkan ke Sumber Data