'Declaration Public Event ConnectionLost As ConnectionLostEventHandler
public event ConnectionLostEventHandler ConnectionLost
Event Data
The event handler receives an argument of type ConnectionLostEventArgs containing data related to this event. The following ConnectionLostEventArgs properties provide information specific to this event.
| Property | Description |
|---|---|
| AttemptNumber | The number of attempts to reconnect. |
| Cause | The reason of the connection loss. |
| Component | The object where the connection loss occurs. |
| Context | The state of the connection when connection is lost. |
| RetryMode | The application behavior when connection is lost. |
Example
SqlConnection conn = new SqlConnection("User Id=sa;Server=localhost;Initial Catalog=Test;"); conn.LocalFailover = true; conn.ConnectionLost += new ConnectionLostEventHandler(conn_ConnectionLost); static void conn_ConnectionLost(object sender, ConnectionLostEventArgs e) { if (e.Cause == ConnectionLostCause.Execute) { if (e.Context == ConnectionLostContext.None) e.RetryMode = RetryMode.Reexecute; else e.RetryMode = RetryMode.Raise; } else e.RetryMode = RetryMode.Raise; }
Dim conn As SqlConnection = New SqlConnection("User Id=sa;Server=localhost;Initial Catalog=Test;") conn.LocalFailover = True AddHandler conn.ConnectionLost, AddressOf conn_ConnectionLost Sub conn_ConnectionLost(ByVal sender As Object, ByVal e As ConnectionLostEventArgs) If e.Cause = ConnectionLostCause.Execute Then If e.Context = ConnectionLostContext.None Then e.RetryMode = RetryMode.Reexecute Else e.RetryMode = RetryMode.Raise End If Else e.RetryMode = RetryMode.Raise End If End Sub
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also