StateChangeEventArgs Class
Provides data for the state change event of a .NET Framework data provider.
Assembly: System.Data (in System.Data.dll)
| Name | Description | |
|---|---|---|
![]() | StateChangeEventArgs(ConnectionState, ConnectionState) | Initializes a new instance of the StateChangeEventArgs class, when given the original state and the current state of the object. |
| Name | 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. |
| Name | Description | |
|---|---|---|
![]() | Equals(Object) | Determines whether the specified object is equal to the current object.(Inherited from Object.) |
![]() | GetHashCode() | Serves as the default hash function. (Inherited from Object.) |
![]() | GetType() | |
![]() | ToString() | Returns a string that represents the current object.(Inherited from Object.) |
The data is used by the StateChange property of the OleDbConnection and the StateChange property of the SqlConnection.
The following example shows how to use the StateChange event within the SqlConnection class.
// Handler for OnStateChange event. protected static void OnStateChange(object sender, StateChangeEventArgs e) { PrintEventArgs(e); } static void Main() { FillDataSet(); } static private void FillDataSet() { string connectionString = GetConnectionString(); string queryString = "SELECT ProductID, UnitPrice from dbo.Products;"; // Create a DataAdapter. using (SqlDataAdapter dataAdapter = new SqlDataAdapter(queryString, connectionString)) { // Add the handlers. dataAdapter.SelectCommand.Connection.StateChange += new StateChangeEventHandler(OnStateChange); // Create a DataSet. DataSet dataSet = new DataSet(); // Fill the DataSet, which fires several StateChange events. dataAdapter.Fill(dataSet, 0, 5, "Table"); } } protected static void PrintEventArgs(StateChangeEventArgs args) { Console.WriteLine("StateChangeEventArgs"); Console.WriteLine(" OriginalState= {0} CurrentState= {1}", args.OriginalState, args.CurrentState); } static private string GetConnectionString() { // To avoid storing the connection string in your code, // you can retrieve it from a configuration file. return "Data Source=(local);Initial Catalog=Northwind;" + "Integrated Security=true"; }
Available since 10
.NET Framework
Available since 1.1
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

