DataAdapter Class latest version

Constructors

• DataAdapter()   protected Initializes a new instance of a DataAdapter class.
• DataAdapter(DataAdapter)   protected Initializes a new instance of a DataAdapter class from an existing object of the same type.

Methods

• CloneInternals()   protectedvirtual Creates a copy of this instance of DataAdapter.
• CreateTableMappings()   protectedvirtual Creates a new DataTableMappingCollection.
• Dispose(Boolean)   protectedvirtual Releases the unmanaged resources used by the DataAdapter and optionally releases the managed resources.
• Fill(DataSet)   virtual Adds or refreshes rows in the DataSet to match those in the data source.
• Fill(DataSet, String, IDataReader, Int32, Int32)   protectedvirtual Adds or refreshes rows in a specified range in the DataSet to match those in the data source using the DataSet and DataTable names.
• Fill(DataTable, IDataReader)   protectedvirtual Adds or refreshes rows in the DataTable to match those in the data source using the DataTable name and the specified IDataReader.
• Fill(DataTable[], IDataReader, Int32, Int32)   protectedvirtual Adds or refreshes rows in a specified range in the collection of DataTable objects to match those in the data source.
• FillSchema(DataSet, SchemaType)   virtual Adds a DataTable to the specified DataSet and configures the schema to match that in the data source based on the specified SchemaType.
• FillSchema(DataSet, SchemaType, String, IDataReader)   protectedvirtual Adds a DataTable to the specified DataSet.
• FillSchema(DataTable, SchemaType, IDataReader)   protectedvirtual Adds a DataTable to the specified DataSet.
• GetFillParameters()   virtual Gets the parameters set by the user when executing an SQL SELECT statement.
• HasTableMappings()   protected Indicates whether a DataTableMappingCollection has been created.
• OnFillError(FillErrorEventArgs)   protectedvirtual Invoked when an error occurs during a Fill.
• ResetFillLoadOption()   Resets FillLoadOption to its default state and causes Fill(System.Data.DataSet) to honor AcceptChangesDuringFill.
• ShouldSerializeAcceptChangesDuringFill()   virtual Determines whether the AcceptChangesDuringFill property should be persisted.
• ShouldSerializeFillLoadOption()   virtual Determines whether the FillLoadOption property should be persisted.
• ShouldSerializeTableMappings()   protectedvirtual Determines whether one or more DataTableMapping objects exist and they should be persisted.
• Update(DataSet)   virtual Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified DataSet from a DataTable named "Table."

Properties

• 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.
• AcceptChangesDuringUpdate   Gets or sets whether AcceptChanges is called during a Update(System.Data.DataSet).
• ContinueUpdateOnError   Gets or sets a value that specifies whether to generate an exception when an error is encountered during a row update.
• FillLoadOption   Gets or sets the LoadOption that determines how the adapter fills the DataTable from the DbDataReader.
• MissingMappingAction   sealed Determines the action to take when incoming data does not have a matching table or column.
• MissingSchemaAction   sealed Determines the action to take when existing DataSet schema does not match incoming data.
• ReturnProviderSpecificTypes   virtual Gets or sets whether the Fill method should return provider-specific values or common CLS-compliant values.
• System.Data.IDataAdapter.TableMappings   privatesealed Indicates how a source table is mapped to a dataset table.
• TableMappings   Gets a collection that provides the master mapping between a source table and a DataTable.

Events

• FillError   Returned when an error occurs during a fill operation.

Assemblies

• netstandard
• System.Data.Common