StateChangeEventArgs Class

 

Provides data for the state change event of a .NET Framework data provider.

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

System.Object
  System.EventArgs
    System.Data.StateChangeEventArgs

public sealed class StateChangeEventArgs : EventArgs

NameDescription
System_CAPS_pubmethodStateChangeEventArgs(ConnectionState, ConnectionState)

Initializes a new instance of the StateChangeEventArgs class, when given the original state and the current state of the object.

NameDescription
System_CAPS_pubpropertyCurrentState

Gets the new state of the connection. The connection object will be in the new state already when the event is fired.

System_CAPS_pubpropertyOriginalState

Gets the original state of the connection.

NameDescription
System_CAPS_pubmethodEquals(Object)

Determines whether the specified object is equal to the current object.(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

Serves as the default hash function. (Inherited from Object.)

System_CAPS_pubmethodGetType()

Gets the Type of the current instance.(Inherited from Object.)

System_CAPS_pubmethodToString()

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";
}

Universal Windows Platform
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.

Return to top
Show: