UpdateRowSource
This enumeration is used to specify the
IDbCommand.UpdatedRowSource property (and the same
property for provider-specific Command objects).
It’s relevant only when DataSet
changes are committed using a data adapter. This value specifies
whether updated values in the data source are used to update the
source row in the DataSet. It eliminates the need
to use a query to retrieve the updated data and to subsequently
update the DataSet.
This technique can be used only when updating the data source with a
stored procedure. That’s because by default, after
an update operation, a database won’t return any
information beside the number of rows affected. However, you can
create a stored procedure that returns one or more updated values
(use OutputParameters) or one that returns the
updated row (use FirstReturnedRecord). The
default is Both.
public enum UpdateRowSource { None = 0, OutputParameters = 1, FirstReturnedRecord = 2, Both = 3 }
System.Object
→
System.ValueType
→
System.Enum(System.IComparable, System.IFormattable, System.IConvertible)
→
UpdateRowSource