This class represents a connection to an OLE DB data source, which can be opened (in order to execute a SQL command) or closed. For information about the basic OleDbConnection methods and properties, refer to the reference for the System.Data.IDbConnection interface, which OleDbCommand implements. If an error is generated by the data source when performing an operation over a connection, an OleDbException is thrown. In addition, the OleDbConnection provides some additional provider-specific read-only properties, such as Provider (the name of the provider, as in MSDASQL), and ServerVersion (a string with the data source version in the format xx.xx.xxxx). The version maps to the OLE DB DBPROP_DBMSVER property. If this isn't supported by the underlying OLE DB provider, an empty string is returned. The OLE DB provider implements connection pooling through COM+, which allow connections to be reused on the same computer, provided clients use an identical connection string. public sealed class OleDbConnection : System.ComponentModel.Component , ICloneable, System.Data.IDbConnection { // Public Constructors public OleDbConnection ( ); public OleDbConnection ( string connectionString ); // Public Instance Properties public string ConnectionString {set; get; } // implements System.Data.IDbConnection public int ConnectionTimeout {get; } // implements System.Data.IDbConnection public string Database {get; } // implements System.Data.IDbConnection public string DataSource {get; } public string Provider {get; } public string ServerVersion {get; } public ConnectionState State {get; } // implements System.Data.IDbConnection // Public Static Methods public static void ReleaseObjectPool ( ); // Public Instance Methods public OleDbTransaction BeginTransaction ( ); public OleDbTransaction BeginTransaction (System.Data.IsolationLevel isolationLevel ); public void ChangeDatabase ( string value ); // implements System.Data.IDbConnection public void Close ( ); // implements System.Data.IDbConnection public OleDbCommand CreateCommand ( ); public void EnlistDistributedTransaction (System.EnterpriseServices.ITransaction transaction ); public DataTable GetOleDbSchemaTable (Guid schema , object[ ] restrictions ); public void Open ( ); // implements System.Data.IDbConnection // Protected Instance Methods protected override void Dispose ( bool disposing ); // overrides System.ComponentModel.Component // Events public event OleDbInfoMessageEventHandler InfoMessage ; public event StateChangeEventHandler StateChange ; } Hierarchy System.Object Returned ByOleDbCommand.Connection , OleDbTransaction.Connection Passed ToOleDbCommand.{Connection , OleDbCommand( )} , OleDbDataAdapter.OleDbDataAdapter( ) ![]() |