Export (0) Print
Expand All

SqlConnection.StateChange Event

.NET Framework 1.1

Occurs when the state of the connection changes.

[Visual Basic]
Public Event StateChange As StateChangeEventHandler
[C#]
public event StateChangeEventHandler StateChange;
[C++]
public: __event StateChangeEventHandler* StateChange;

[JScript] In JScript, you can handle the events defined by a class, but you cannot define your own.

Event Data

The event handler receives an argument of type StateChangeEventArgs containing data related to this event. The following StateChangeEventArgs properties provide information specific to this event.

Property Description
CurrentState Gets the new state of the connection. The connection object will be in the new state already when the event is fired.
OriginalState Gets the original state of the connection.

Remarks

The StateChange event fires whenever the State changes from closed to opened, or from opened to closed. StateChange fires immediately after the SqlConnection transitions.

If an event handler throws an exception from within the StateChange event, the exception propagates to the caller of the Open or Close method.

The StateChange event is not raised unless you explicitly call Close or Dispose. For more information, see Working with Connection Events.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

SqlConnection Class | SqlConnection Members | System.Data.SqlClient Namespace

Show:
© 2014 Microsoft