Export (0) Print
Expand All

SqlDataAdapter Members

SqlDataAdapter overview

Public Constructors

public constructorSqlDataAdapter Constructor

Supported by the .NET Compact Framework.

Overloaded. Initializes a new instance of the SqlDataAdapter class.

Public Properties

public propertyAcceptChangesDuringFill (inherited from DataAdapter)

Supported by the .NET Compact Framework.

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.
public propertyContainer (inherited from Component) Gets the IContainer that contains the Component.
public propertyContinueUpdateOnError (inherited from DataAdapter)

Supported by the .NET Compact Framework.

Gets or sets a value that specifies whether to generate an exception when an error is encountered during a row update.
public propertyDeleteCommand

Supported by the .NET Compact Framework.

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

Supported by the .NET Compact Framework.

Gets or sets a Transact-SQL statement or stored procedure to insert new records into the data source.
public propertyMissingMappingAction (inherited from DataAdapter)

Supported by the .NET Compact Framework.

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

Supported by the .NET Compact Framework.

Determines the action to take when existing DataSet schema does not match incoming data.
public propertySelectCommand

Supported by the .NET Compact Framework.

Gets or sets a Transact-SQL statement or stored procedure used to select records in the data source.
public propertySite (inherited from Component) Gets or sets the ISite of the Component.
public propertyTableMappings (inherited from DataAdapter)

Supported by the .NET Compact Framework.

Gets a collection that provides the master mapping between a source table and a DataTable.
public propertyUpdateCommand

Supported by the .NET Compact Framework.

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

Public Methods

public methodCreateObjRef (inherited from MarshalByRefObject) Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
public methodDispose (inherited from Component)

Supported by the .NET Compact Framework.

Overloaded. Releases the resources used by the Component.
public methodEquals (inherited from Object)

Supported by the .NET Compact Framework.

Overloaded. Determines whether two Object instances are equal.
public methodFill (inherited from DbDataAdapter)

Supported by the .NET Compact Framework.

Overloaded. Overridden. Adds or refreshes rows in the DataSet to match those in the data source.
public methodFillSchema (inherited from DbDataAdapter)

Supported by the .NET Compact Framework.

Overloaded. Overridden. Adds a DataTable to a DataSet and configures the schema to match that in the data source.
public methodGetFillParameters (inherited from DbDataAdapter)

Supported by the .NET Compact Framework.

Overridden. Gets the parameters set by the user when executing an SQL SELECT statement.
public methodGetHashCode (inherited from Object)

Supported by the .NET Compact Framework.

Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table.
public methodGetLifetimeService (inherited from MarshalByRefObject) Retrieves the current lifetime service object that controls the lifetime policy for this instance.
public methodGetType (inherited from Object)

Supported by the .NET Compact Framework.

Gets the Type of the current instance.
public methodInitializeLifetimeService (inherited from MarshalByRefObject) Obtains a lifetime service object to control the lifetime policy for this instance.
public methodToString (inherited from Object)

Supported by the .NET Compact Framework.

Returns a String that represents the current Object.
public methodUpdate (inherited from DbDataAdapter)

Supported by the .NET Compact Framework.

Overloaded. Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the DataSet.

Public Events

public eventDisposed (inherited from Component) Adds an event handler to listen to the Disposed event on the component.
public eventFillError (inherited from DbDataAdapter) Returned when an error occurs during a fill operation.
public eventRowUpdated Occurs during Update after a command is executed against the data source. The attempt to update is made, so the event fires.
public eventRowUpdating Occurs during Update before a command is executed against the data source. The attempt to update is made, so the event fires.

Protected Properties

protected propertyDesignMode (inherited from Component) Gets a value that indicates whether the Component is currently in design mode.
protected propertyEvents (inherited from Component) Gets the list of event handlers that are attached to this Component.

Protected Methods

protected methodCloneInternals (inherited from DataAdapter)

Supported by the .NET Compact Framework.

Obsolete. Creates a copy of this instance of DataAdapter.
protected methodCreateRowUpdatedEvent

Supported by the .NET Compact Framework.

Overridden. See DbDataAdapter.CreateRowUpdatedEvent.
protected methodCreateRowUpdatingEvent

Supported by the .NET Compact Framework.

Overridden. See DbDataAdapter.CreateRowUpdatingEvent.
protected methodCreateTableMappings (inherited from DataAdapter)

Supported by the .NET Compact Framework.

Creates a new DataTableMappingCollection.
protected methodDispose

Supported by the .NET Compact Framework.

Overloaded. Overridden. Releases the resources used by the SqlDataAdapter.
protected methodFill (inherited from DbDataAdapter)

Supported by the .NET Compact Framework.

Overloaded. Overridden. Adds or refreshes rows in the DataSet to match those in the data source.
protected methodFillSchema (inherited from DbDataAdapter)

Supported by the .NET Compact Framework.

Overloaded. Overridden. Adds a DataTable to a DataSet and configures the schema to match that in the data source.
protected methodFinalize (inherited from Component)

Supported by the .NET Compact Framework.

Overridden. Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection.

In C# and C++, finalizers are expressed using destructor syntax.

protected methodGetService (inherited from Component) Returns an object that represents a service provided by the Component or by its Container.
protected methodMemberwiseClone (inherited from Object)

Supported by the .NET Compact Framework.

Creates a shallow copy of the current Object.
protected methodOnFillError (inherited from DbDataAdapter)

Supported by the .NET Compact Framework.

Raises the FillError event.
protected methodOnRowUpdated

Supported by the .NET Compact Framework.

Overridden. Raises the RowUpdated event.
protected methodOnRowUpdating

Supported by the .NET Compact Framework.

Overridden. Raises the RowUpdating event.
protected methodShouldSerializeTableMappings (inherited from DataAdapter) Determines whether one or more DataTableMapping objects exist and they should be persisted.
protected methodUpdate (inherited from DbDataAdapter)

Supported by the .NET Compact Framework.

Overloaded. Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the DataSet.

See Also

SqlDataAdapter Class | System.Data.SqlClient Namespace

Show:
© 2014 Microsoft