Name
RowUpdatedEventArgs
Synopsis
This System.EventArgs
class provides data for
event handlers for the RowUpdated
event of the
DataAdapter
. This includes the command that was
just completed (Command
); any errors that were
encountered (Errors
); the number of rows that
were changed, inserted, or deleted in response to the command
(RecordsAffected
); the type of SQL statement the
command executed (StatementType
); and the
relevant System.Data.DataRow
object
(Row
). You can set the Status
property to
System.Data.UpdateStatus.SkipCurrentRow
to bypass
a row if there was an error. One easy way to determine if an error
occurred is simply to check the number of records affected. If this
value is 0, the statement did not complete as expected.
Each provider derives a provider-specific version of the
RowUpdatedEventArgs
class. Although the
RowUpdated
event is supported by most
DataAdapter
objects. It isn’t
part of any interface or either base class
(DataAdapter
or
System.Data.IDbDataAdapter
). Hence, you
can’t attach a generic event handler to this event.
public abstract class RowUpdatedEventArgs : EventArgs { // Protected Constructors protected RowUpdatedEventArgs(System.Data.DataRowdataRow
, System.Data.IDbCommandcommand
, System.Data.StatementTypestatementType
, DataTableMappingtableMapping
); // Public Instance Properties public IDbCommand Command{get; } public Exception Errors{set; get; } public int RecordsAffected{get; } public DataRow Row{get; } public StatementType StatementType{get; } public ...
Get ADO.NET in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.