OleDbConnection.ConnectionTimeout プロパティとは何？わかりやすく解説 Weblio辞書

.NET Framework クラスライブラリリファレンス

索引トップ用語の索引ランキング

OleDbConnection.ConnectionTimeout プロパティ

接続の確立の試行を開始してから、その試行を終了してエラーを生成するまでの待機時間を取得します。

名前空間: System.Data.OleDb
アセンブリ: System.Data (system.data.dll 内)
構文

Visual Basic (宣言)

Public Overrides ReadOnly
 Property ConnectionTimeout As Integer

Visual Basic (使用法)

Dim instance As OleDbConnection
Dim value As Integer

value = instance.ConnectionTimeout

public override int ConnectionTimeout { get;
 }

C++

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

/** @property */
public int get_ConnectionTimeout ()

JScript

public override function get
 ConnectionTimeout () : int

プロパティ値
接続が開かれるまでの待機時間 (秒)。既定値は 15 秒です。

例外

例外の種類	条件
ArgumentException	設定値が 0 未満です。

解説

0 は、制限なしを示します。ただし、接続の試行が永久的に待機されるため、ConnectionString では使用しないでください。

使用例

OleDbConnection を作成し、そのプロパティの一部を接続文字列に設定する例を次に示します。

Visual Basic

' 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

// 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.
    }

using System;
using System.Data;
using System.Data.OleDb;

class Class1
{
    static void Main()
    {
    }

    // 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.
        }