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 figs/u2192.gif System.ValueType figs/u2192.gif System.Enum(System.IComparable, System.IFormattable , System.IConvertible) figs/u2192.gif 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



ADO. NET in a Nutshell
ADO.NET in a Nutshell
ISBN: 0596003617
EAN: 2147483647
Year: 2005
Pages: 415

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net