Export (0) Print
Expand All

SqlDataAdapter Properties

The SqlDataAdapter type exposes the following members.

  Name Description
Public property AcceptChangesDuringFill Gets or sets a value indicating whether AcceptChanges is called on a DataRow after it is added to the DataTable during any of the Fill operations. (Inherited from DataAdapter.)
Public property AcceptChangesDuringUpdate Gets or sets whether AcceptChanges is called during a Update. (Inherited from DataAdapter.)
Public property Container Gets the IContainer that contains the Component. (Inherited from Component.)
Public property ContinueUpdateOnError Gets or sets a value that specifies whether to generate an exception when an error is encountered during a row update. (Inherited from DataAdapter.)
Public property DeleteCommand Gets or sets a Transact-SQL statement or stored procedure to delete records from the data set.
Protected property FillCommandBehavior Gets or sets the behavior of the command used to fill the data adapter. (Inherited from DbDataAdapter.)
Public property FillLoadOption Gets or sets the LoadOption that determines how the adapter fills the DataTable from the DbDataReader. (Inherited from DataAdapter.)
Public property InsertCommand Gets or sets a Transact-SQL statement or stored procedure to insert new records into the data source.
Public property MissingMappingAction Determines the action to take when incoming data does not have a matching table or column. (Inherited from DataAdapter.)
Public property MissingSchemaAction Determines the action to take when existing DataSet schema does not match incoming data. (Inherited from DataAdapter.)
Public property ReturnProviderSpecificTypes Gets or sets whether the Fill method should return provider-specific values or common CLS-compliant values. (Inherited from DataAdapter.)
Public property SelectCommand Gets or sets a Transact-SQL statement or stored procedure used to select records in the data source.
Public property Site Gets or sets the ISite of the Component. (Inherited from Component.)
Public property TableMappings Gets a collection that provides the master mapping between a source table and a DataTable. (Inherited from DataAdapter.)
Public property UpdateBatchSize Gets or sets the number of rows that are processed in each round-trip to the server. (Overrides DbDataAdapter.UpdateBatchSize.)
Public property UpdateCommand Gets or sets a Transact-SQL statement or stored procedure used to update records in the data source.
Top

  Name Description
Explicit interface implemetation Private property IDataAdapter.TableMappings Indicates how a source table is mapped to a dataset table. (Inherited from DataAdapter.)
Explicit interface implemetation Private property IDbDataAdapter.DeleteCommand For a description of this member, see DeleteCommand.
Explicit interface implemetation Private property IDbDataAdapter.InsertCommand For a description of this member, see InsertCommand.
Explicit interface implemetation Private property IDbDataAdapter.SelectCommand For a description of this member, see SelectCommand.
Explicit interface implemetation Private property IDbDataAdapter.UpdateCommand For a description of this member, see UpdateCommand.
Top
Show:
© 2014 Microsoft