System.Data.OleDb Namespace

.NET Framework Class Library

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

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 OleDbDataAdapter, you can fill a memory-resident DataSet that you can use to query and update the data source.

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

Classes

	Class	Description
	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 DataSet with the associated database. This class cannot be inherited.
	OleDbConnection	Represents an open connection to a data source.
	OleDbConnectionStringBuilder	Provides a simple way to create and manage the contents of connection strings used by the OleDbConnection class.
	OleDbDataAdapter	Represents a set of data commands and a database connection that are used to fill the 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.
	OleDbEnumerator	Provides a mechanism for enumerating all available OLE DB providers within the local network.
	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.
	OleDbFactory	Represents a set of methods for creating instances of the OLEDB provider's implementation of the data source classes.
	OleDbInfoMessageEventArgs	Provides data for the InfoMessage event. This class cannot be inherited.
	OleDbMetaDataCollectionNames	Provides a list of constants for use with the GetSchema method to retrieve metadata collections.
	OleDbMetaDataColumnNames	Provides static values that are used for the column names in the OleDbMetaDataCollectionNames objects contained in the DataTable. The DataTable is created by the GetSchema method.
	OleDbParameter	Represents a parameter to an OleDbCommand and optionally its mapping to a DataSet column. This class cannot be inherited.
	OleDbParameterCollection	Represents a collection of parameters relevant to an OleDbCommand as well as their respective mappings to columns in a 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 RowUpdated event.
	OleDbRowUpdatingEventArgs	Provides data for the RowUpdating event.
	OleDbSchemaGuid	Returns the type of schema table specified by the GetOleDbSchemaTable method.
	OleDbTransaction	Represents an SQL transaction to be made at a data source. This class cannot be inherited.

Delegates

	Delegate	Description
	OleDbInfoMessageEventHandler	Represents the method that will handle the InfoMessage event of an OleDbConnection.
	OleDbRowUpdatedEventHandler	Represents the method that will handle the RowUpdated event of an OleDbDataAdapter.
	OleDbRowUpdatingEventHandler	Represents the method that will handle the RowUpdating event of an OleDbDataAdapter.

Enumerations

	Enumeration	Description
	OleDbLiteral	Returns information about literals used in text commands, data values, and database objects.
	OleDbType	Specifies the data type of a field, a property, for use in an OleDbParameter.