System.Data.OleDb Namespace

The System.Data.OleDb namespace is the.NET Framework Data Provider for OLE DB.

Remarks

The.NET Framework Data Provider for OLE DB describes a collection of classes used to access an OLE DB data source in the managed space. Using the System.Data.OleDb.OleDbDataAdapter, you can fill a memory-resident System.Data.DataSet that you can use to query and update the data source.

For information about how to use this namespace, see the System.Data.OleDb.OleDbDataAdapter, System.Data.OleDb.OleDbDataReader, System.Data.OleDb.OleDbCommand, and System.Data.OleDb.OleDbConnection classes.

Classes

TypeReason
OleDbCommand

Represents an SQL statement or stored procedure to execute against a data source.

OleDbCommandBuilder

Automatically generates single-table commands that are used to reconcile changes made to a System.Data.DataSet with the associated database. This class cannot be inherited.

OleDbConnection

Represents an open connection to a data source.

OleDbDataAdapter

Represents a set of data commands and a database connection that are used to fill the System.Data.DataSet and update the data source.

OleDbDataReader

Provides a way of reading a forward-only stream of data rows from a data source. This class cannot be inherited.

OleDbError

Collects information relevant to a warning or error returned by the data source.

OleDbErrorCollection

Collects all errors generated by the .NET Framework Data Provider for OLE DB. This class cannot be inherited.

OleDbException

The exception that is thrown when the underlying provider returns a warning or error for an OLE DB data source. This class cannot be inherited.

OleDbInfoMessageEventArgs

Provides data for the System.Data.OleDb.OleDbConnection.InfoMessage event. This class cannot be inherited.

OleDbInfoMessageEventHandler

Represents the method that will handle the System.Data.OleDb.OleDbConnection.InfoMessage event of an System.Data.OleDb.OleDbConnection.

OleDbLiteral

Returns information about literals used in text commands, data values, and database objects.

OleDbMetaDataCollectionNames

Provides a list of constants for use with the GetSchema method to retrieve metadata collections.

OleDbParameter

Represents a parameter to an System.Data.OleDb.OleDbCommand and optionally its mapping to a System.Data.DataSet column. This class cannot be inherited.

OleDbParameterCollection

Represents a collection of parameters relevant to an System.Data.OleDb.OleDbCommand as well as their respective mappings to columns in a System.Data.DataSet.

OleDbPermission

Enables the .NET Framework Data Provider for OLE DB to help make sure that a user has a security level sufficient to access an OLE DB data source.

OleDbPermissionAttribute

Associates a security action with a custom security attribute.

OleDbRowUpdatedEventArgs

Provides data for the System.Data.OleDb.OleDbDataAdapter.RowUpdated event.

OleDbRowUpdatedEventHandler

Represents the method that will handle the System.Data.OleDb.OleDbDataAdapter.RowUpdated event of an System.Data.OleDb.OleDbDataAdapter.

OleDbRowUpdatingEventArgs

Provides data for the System.Data.OleDb.OleDbDataAdapter.RowUpdating event.

OleDbRowUpdatingEventHandler

Represents the method that will handle the System.Data.OleDb.OleDbDataAdapter.RowUpdating event of an System.Data.OleDb.OleDbDataAdapter.

OleDbSchemaGuid

Returns the type of schema table specified by the System.Data.OleDb.OleDbConnection.GetOleDbSchemaTable(Guid, Object[]) method.

OleDbTransaction

Represents an SQL transaction to be made at a data source. This class cannot be inherited.

OleDbType

Specifies the data type of a field, a property, for use in an System.Data.OleDb.OleDbParameter.