SqlDataAdapter Methods (System.Data.SqlClient)

This page is specific to

Microsoft Visual Studio 2008/.NET Framework 3.5

Other versions are also available for the following:

.NET Framework Class Library

SqlDataAdapter Methods

The SqlDataAdapter type exposes the following members.

Methods

	Name	Description
	AddToBatch	Adds a IDbCommand to the current batch. (Inherited from DbDataAdapter.)
	ClearBatch	Removes all IDbCommand objects from the batch. (Inherited from DbDataAdapter.)
	CloneInternals	Obsolete. Creates a copy of this instance of DataAdapter. (Inherited from DataAdapter.)
	CreateObjRef	Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject.)
	CreateRowUpdatedEvent	Initializes a new instance of the RowUpdatedEventArgs class. (Inherited from DbDataAdapter.)
	CreateRowUpdatingEvent	Initializes a new instance of the RowUpdatingEventArgs class. (Inherited from DbDataAdapter.)
	CreateTableMappings	Creates a new DataTableMappingCollection. (Inherited from DataAdapter.)
	Dispose	Overloaded. Releases the resources used by the Component.
	Equals	Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
	ExecuteBatch	Executes the current batch. (Inherited from DbDataAdapter.)
	Fill	Overloaded. Adds or refreshes rows in the DataSet to match those in the data source.
	FillSchema	Overloaded. Adds a DataTable to the specified DataSet.
	Finalize	Overloaded.
	GetBatchedParameter	Returns a IDataParameter from one of the commands in the current batch. (Inherited from DbDataAdapter.)
	GetBatchedRecordsAffected	Returns information about an individual update attempt within a larger batched update. (Inherited from DbDataAdapter.)
	GetFillParameters	Gets the parameters set by the user when executing an SQL SELECT statement. (Inherited from DbDataAdapter.)
	GetHashCode	Serves as a hash function for a particular type. (Inherited from Object.)
	GetLifetimeService	Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
	GetService	Returns an object that represents a service provided by the Component or by its Container. (Inherited from Component.)
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	HasTableMappings	Indicates whether a DataTableMappingCollection has been created. (Inherited from DataAdapter.)
	InitializeBatching	Initializes batching for the DbDataAdapter. (Inherited from DbDataAdapter.)
	InitializeLifetimeService	Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
	MemberwiseClone	Overloaded.
	OnFillError	Overloaded.
	OnRowUpdated	Raises the RowUpdated event of a .NET Framework data provider. (Inherited from DbDataAdapter.)
	OnRowUpdating	Raises the RowUpdating event of a .NET Framework data provider. (Inherited from DbDataAdapter.)
	ResetFillLoadOption	Resets FillLoadOption to its default state and causes DataAdapter..::.Fill to honor AcceptChangesDuringFill. (Inherited from DataAdapter.)
	ShouldSerializeAcceptChangesDuringFill	Determines whether the AcceptChangesDuringFill property should be persisted. (Inherited from DataAdapter.)
	ShouldSerializeFillLoadOption	Determines whether the FillLoadOption property should be persisted. (Inherited from DataAdapter.)
	ShouldSerializeTableMappings	Determines whether one or more DataTableMapping objects exist and they should be persisted. (Inherited from DataAdapter.)
	TerminateBatching	Ends batching for the DbDataAdapter. (Inherited from DbDataAdapter.)
	ToString	Overloaded.
	Update	Overloaded. Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the DataSet.

Top

Reference

SqlDataAdapter Class

System.Data.SqlClient Namespace