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