ADO.NET in a Nutshell

Name

UpdateRowSource

Synopsis

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

}

Hierarchy

System.Object → System.ValueType → System.Enum(System.IComparable, System.IFormattable, System.IConvertible) → UpdateRowSource

Returned By

IDbCommand.UpdatedRowSource, System.Data.OleDb.OleDbCommand.UpdatedRowSource, System.Data.OracleClient.OracleCommand.UpdatedRowSource, System.Data.SqlClient.SqlCommand.UpdatedRowSource

Passed To

IDbCommand.UpdatedRowSource, System.Data.OleDb.OleDbCommand.UpdatedRowSource, System.Data.OracleClient.OracleCommand.UpdatedRowSource, System.Data.SqlClient.SqlCommand.UpdatedRowSource