SqlDataAdapter Properties

 

Namespace:   System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

NameDescription
System_CAPS_pubpropertyAcceptChangesDuringFill

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.)

System_CAPS_pubpropertyAcceptChangesDuringUpdate

Gets or sets whether AcceptChanges is called during a Update.(Inherited from DataAdapter.)

System_CAPS_pubpropertyContainer

Gets the IContainer that contains the Component.(Inherited from Component.)

System_CAPS_pubpropertyContinueUpdateOnError

Gets or sets a value that specifies whether to generate an exception when an error is encountered during a row update.(Inherited from DataAdapter.)

System_CAPS_pubpropertyDeleteCommand

Gets or sets a Transact-SQL statement or stored procedure to delete records from the data set.

System_CAPS_protpropertyFillCommandBehavior

Gets or sets the behavior of the command used to fill the data adapter.(Inherited from DbDataAdapter.)

System_CAPS_pubpropertyFillLoadOption

Gets or sets the LoadOption that determines how the adapter fills the DataTable from the DbDataReader.(Inherited from DataAdapter.)

System_CAPS_pubpropertyInsertCommand

Gets or sets a Transact-SQL statement or stored procedure to insert new records into the data source.

System_CAPS_pubpropertyMissingMappingAction

Determines the action to take when incoming data does not have a matching table or column.(Inherited from DataAdapter.)

System_CAPS_pubpropertyMissingSchemaAction

Determines the action to take when existing DataSet schema does not match incoming data.(Inherited from DataAdapter.)

System_CAPS_pubpropertyReturnProviderSpecificTypes

Gets or sets whether the Fill method should return provider-specific values or common CLS-compliant values.(Inherited from DataAdapter.)

System_CAPS_pubpropertySelectCommand

Gets or sets a Transact-SQL statement or stored procedure used to select records in the data source.

System_CAPS_pubpropertySite

Gets or sets the ISite of the Component.(Inherited from Component.)

System_CAPS_pubpropertyTableMappings

Gets a collection that provides the master mapping between a source table and a DataTable.(Inherited from DataAdapter.)

System_CAPS_pubpropertyUpdateBatchSize

Gets or sets the number of rows that are processed in each round-trip to the server.(Overrides DbDataAdapter.UpdateBatchSize.)

System_CAPS_pubpropertyUpdateCommand

Gets or sets a Transact-SQL statement or stored procedure used to update records in the data source.

NameDescription
System_CAPS_pubinterfaceSystem_CAPS_privpropertyIDataAdapter.TableMappings

Indicates how a source table is mapped to a dataset table.(Inherited from DataAdapter.)

System_CAPS_pubinterfaceSystem_CAPS_privpropertyIDbDataAdapter.DeleteCommand

For a description of this member, see DeleteCommand.

System_CAPS_pubinterfaceSystem_CAPS_privpropertyIDbDataAdapter.InsertCommand

For a description of this member, see InsertCommand.

System_CAPS_pubinterfaceSystem_CAPS_privpropertyIDbDataAdapter.SelectCommand

For a description of this member, see SelectCommand.

System_CAPS_pubinterfaceSystem_CAPS_privpropertyIDbDataAdapter.UpdateCommand

For a description of this member, see UpdateCommand.

Return to top
Show: