dotConnect Universal Documentation
Devart.Data.Universal Namespace / UniDataAdapter Class / RowUpdated Event

In This Topic
    RowUpdated Event
    In This Topic

    Occurs during System.Data.Common.DbDataAdapter.Update(System.Data.DataSet) after a command is executed against the data source. The attempt to update is made, so the event fires.

    Syntax
    'Declaration
     
    Public Event RowUpdated As UniRowUpdatedEventHandler
    public event UniRowUpdatedEventHandler RowUpdated
    Event Data

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

    PropertyDescription
    Gets the System.Data.IDbCommand executed when System.Data.Common.DbDataAdapter.Update(System.Data.DataSet) is called.  
    Gets any errors generated by the .NET Framework data provider when the System.Data.Common.RowUpdatedEventArgs.Command was executed.  
    Gets the number of rows changed, inserted, or deleted by execution of the SQL statement.  
    Gets the System.Data.DataRow sent through an System.Data.Common.DbDataAdapter.Update(System.Data.DataSet).  
    Gets the number of rows processed in a batch of updated records.  
    Gets the type of SQL statement executed.  
    Gets the System.Data.UpdateStatus of the System.Data.Common.RowUpdatedEventArgs.Command property.  
    Gets the System.Data.Common.DataTableMapping sent through an System.Data.Common.DbDataAdapter.Update(System.Data.DataSet).  
    Remarks
    The event handler receives an argument of type UniRowUpdatedEventArgs containing data related to this event. The following UniRowUpdatedEventArgs properties provide information specific to this event.
    Property Description
    UniRowUpdatedEventArgs.Command Gets the UniCommand executed when System.Data.Common.DbDataAdapter.Update(System.Data.DataSet) is called.
    Errors (inherited from System.Data.Common.RowUpdatedEventArgs) Gets any errors generated by the .NET data provider when the System.Data.Common.DbDataAdapter.Command(System.Data.DataSet) was executed.
    RecordsAffected (inherited from System.Data.Common.RowUpdatedEventArgs) Gets the number of rows changed, inserted, or deleted by execution of the SQL statement.
    Row (inherited from System.Data.Common.RowUpdatedEventArgs) Gets the System.Data.DataRow sent through an System.Data.Common.DbDataAdapter.Update(System.Data.DataSet).
    StatementType (System.Data.Common.RowUpdatedEventArgs) Gets the type of SQL statement executed.
    Status (inherited from System.Data.Common.RowUpdatedEventArgs) Gets the UpdateStatus of the System.Data.Common.DbDataAdapter.Command(System.Data.DataSet).
    TableMapping (inherited from System.Data.Common.RowUpdatedEventArgs) Gets the DataTableMapping sent through an System.Data.Common.DbDataAdapter.Update(System.Data.DataSet).

    When using the System.Data.Common.DbDataAdapter.Update(System.Data.DataSet) method, there are two events that occur per data row updated. The order of execution is as follows:

    1. The values in the System.Data.DataRow are moved to the parameter values.
    2. The RowUpdating event is raised.
    3. The command executes.
    4. If the System.Data.UpdateRowSource enumeration is set to System.Data.UpdateRowSource.FirstReturnedRecordS, the first returned result is placed in the System.Data.DataRow.
    5. If there are output parameters, they are placed in the System.Data.DataRow.
    6. The RowUpdated event is raised.
    7. System.Data.DataRow.AcceptChanges is called.
    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