Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content

System.Data.OleDb Namespace

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.

Public classOleDbCommandRepresents an SQL statement or stored procedure to execute against a data source.
Public classOleDbCommandBuilderAutomatically generates single-table commands that are used to reconcile changes made to a DataSet with the associated database. This class cannot be inherited.
Public classOleDbConnectionRepresents an open connection to a data source.
Public classOleDbConnectionStringBuilderProvides a simple way to create and manage the contents of connection strings used by the OleDbConnection class.
Public classOleDbDataAdapterRepresents a set of data commands and a database connection that are used to fill the DataSet and update the data source.
Public classOleDbDataReaderProvides a way of reading a forward-only stream of data rows from a data source. This class cannot be inherited.
Public classOleDbEnumeratorProvides a mechanism for enumerating all available OLE DB providers within the local network.
Public classOleDbErrorCollects information relevant to a warning or error returned by the data source.
Public classOleDbErrorCollectionCollects all errors generated by the .NET Framework Data Provider for OLE DB. This class cannot be inherited.
Public classOleDbExceptionThe exception that is thrown when the underlying provider returns a warning or error for an OLE DB data source. This class cannot be inherited.
Public classOleDbFactoryRepresents a set of methods for creating instances of the OLEDB provider's implementation of the data source classes.
Public classOleDbInfoMessageEventArgsProvides data for the InfoMessage event. This class cannot be inherited.
Public classOleDbMetaDataCollectionNamesProvides a list of constants for use with the GetSchema method to retrieve metadata collections.
Public classOleDbMetaDataColumnNamesProvides 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.
Public classOleDbParameterRepresents a parameter to an OleDbCommand and optionally its mapping to a DataSet column. This class cannot be inherited.
Public classOleDbParameterCollectionRepresents a collection of parameters relevant to an OleDbCommand as well as their respective mappings to columns in a DataSet.
Public classOleDbPermissionEnables 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.
Public classOleDbPermissionAttributeAssociates a security action with a custom security attribute.
Public classOleDbRowUpdatedEventArgsProvides data for the RowUpdated event.
Public classOleDbRowUpdatingEventArgsProvides data for the RowUpdating event.
Public classOleDbSchemaGuidReturns the type of schema table specified by the GetOleDbSchemaTable method.
Public classOleDbTransactionRepresents an SQL transaction to be made at a data source. This class cannot be inherited.

Public delegateOleDbInfoMessageEventHandlerRepresents the method that will handle the InfoMessage event of an OleDbConnection.
Public delegateOleDbRowUpdatedEventHandlerRepresents the method that will handle the RowUpdated event of an OleDbDataAdapter.
Public delegateOleDbRowUpdatingEventHandlerRepresents the method that will handle the RowUpdating event of an OleDbDataAdapter.

Public enumerationOleDbLiteralReturns information about literals used in text commands, data values, and database objects.
Public enumerationOleDbTypeSpecifies the data type of a field, a property, for use in an OleDbParameter.

Community Additions

© 2015 Microsoft