ABSTRACT

OLE DB supports data access from any source for which an OLE DB provider is available. For example, data can be accessed from Microsoft Access, Oracle and Microsoft SQL Server databases, as well as from other formats such as spreadsheets and text files. The classes used to implement OLE DB data access are contained in the System.Data.OleDb namespace. The following classes enable data access:

• OleDbConnection represents a unique connection to a data source. • OleDbCommand represents an SQL statement of stored procedure executed at

the data source. • OleDbDataReader enables the forward-only iteration through the rows of a result

set and read-only access of the row’s column values.