Windows apps
Collapse the table of content
Expand the table of content
Information
Switch
Switch
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

SqlConnection::ConnectionTimeout Property

.NET Framework (current version)
 

Gets the time to wait while trying to establish a connection before terminating the attempt and generating an error.

Namespace:   System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

C#
C++
F#
VB
Copy 
public:
property int ConnectionTimeout {
	virtual int get() override;
}

Property Value

Type: System::Int32

The time (in seconds) to wait for a connection to open. The default value is 15 seconds.

Implements

IDbConnection::ConnectionTimeout

Exception Condition
ArgumentException

The value set is less than 0.

You can set the amount of time a connection waits to time out by using the ConnectTimeout or Connection Timeout keywords in the connection string. A value of 0 indicates no limit, and should be avoided in a ConnectionString because an attempt to connect waits indefinitely.

The following example creates a SqlConnection and sets the Connection Timeout to 30 seconds in the connection string. The code opens the connection and displays the ConnectionTimeout property in the console window.

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

.NET Framework
Available since 1.1
Return to top
Show:
© 2017 Microsoft