UpdateRowSource serializable

UpdateRowSource

serializable

---

System.Data (system.data.dll)

enum

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