Create(TComponent)

Initializes a new instance of the TDbConnection class.

Destroy

Represents the destructor of the TDbConnection class.

CommandCount

The number of assocciated TDbCommand objects.

Commands[Integer]

Returns assocciated TDbCommand objects.

ConnectionIntf

Provides direct access to the ADO.Net DbConnection object.

ConnectionString

Specifies the connection information for the data store.

ConnectionTimeout

Specifies amount of time to attempt a connection.

Database

Gets the name of the current database after a connection is opened, or the database name specified in the connection string before the connection is opened.

DataSets[Integer]

Provides an indexed array of all active datasets for a connection component.

DataSource

Gets the name of the database server to which to connect.

DbParams

Represents property DbParams.

InTransaction

Indicates whether a transaction is in progress.

IsolationLevel

Specifies the transaction isolation level for transactions.

KeepConnection

Specifies whether an application remains connected to a database even if no datasets are open.

LoginPrompt

Specifies whether a login dialog appears immediately before opening a new connection.

OnBeginTransComplete

Occurs after beginning a transaction.

OnCommitTransComplete

Occurs after committing a transaction.

OnConnectComplete

Occurs after starting a connection.

OnDisconnect

Occurs after a connection is terminated.

OnRollbackTransComplete

Occurs after rolling back a transaction.

ProviderFactory

Returns assocciated TDbProviderFactory objects.

ServerVersion

Gets a string that represents the version of the server to which the object is connected.

SQLHourGlass

Represents property SQLHourGlass.

State

Gets a string that describes the state of the connection.

TransactionIntf

Provides direct access to the ADO.Net DbTransaction object.

BeginTransaction

Starts a database transaction.

BeginTransaction(TIsolationLevel)

Starts a database transaction with the specified isolation level.

ChangeDatabase(WideString)

Changes the current database for an open connection.

CheckActive

Checks to see if the connection is active.

CheckDisconnect

Represents method CheckDisconnect.

CheckInactive

Represents method CheckInactive.

CheckOffline

Represents method CheckOffline.

CheckOnline

Represents method CheckOnline.

CloneConnection

Create a copy of the current TDbConnection object.

Commit

Commits the database transaction.

CreateCommand

Creates and returns a DbCommand object associated with the DbConnection.

DoBeginTransaction(TIsolationLevel)

Represents method DoBeginTransaction(TIsolationLevel).

DoBeginTransComplete

Represents method DoBeginTransComplete.

DoCommitTransaction

Represents method DoCommitTransaction.

DoCommitTransComplete

Represents method DoCommitTransComplete.

DoConnect

Represents method DoConnect.

DoConnectComplete

Represents method DoConnectComplete.

DoCreateCommand

Represents method DoCreateCommand.

DoCreateConnection

Represents method DoCreateConnection.

DoDisconnect

Represents method DoDisconnect.

DoDisconnectDataSets

Represents method DoDisconnectDataSets.

DoDisposeTransaction

Represents method DoDisposeTransaction.

DoGetConnectionIntf

Represents method DoGetConnectionIntf.

DoInternalConnect(string,string)

Represents method DoInternalConnect(string,string).

DoInternalDisconnect

Represents method DoInternalDisconnect.

DoRollbackTransaction

Represents method DoRollbackTransaction.

DoRollbackTransComplete

Represents method DoRollbackTransComplete.

Execute(String)

Executes the specified query and returns ADO.Net DataTable.

Execute(String,Variant[])

Executes the specified query by specifying an array of the parameter values and returns ADO.Net DataTable.

ExecuteNonQuery(String)

Executes the specified SQL statement against the connection object.

ExecuteNonQuery(String,Variant[])

Executes the specified SQL statement and the array of the parameter values against the connection object.

ExecuteReader(String)

Executes the specified CommandText against the Connection component, and returns an DbDataReader.

ExecuteReader(String,Variant[])

Executes the specified CommandText and an array of the parameter values against the Connection, and returns an DbDataReader.

ExecuteScalar(String)

Executes the specified CommandText and returns the first column of the first row in the result set returned by the query. All other columns and rows are ignored.

ExecuteScalar(String,Variant[])

Executes the specified CommandText by specifying an array of the parameter values and returns the first column of the first row in the result set returned by the query. All other columns and rows are ignored.

GetConnected

Returns the value of the Connected property.

GetDbParams

Represents method GetDbParams.

GetFieldNames(String,TStrings)

Populates a string list with the names of fields in a table.

GetIndexes(String,TStrings)

Populates a string list with the names of indexes in a table.

GetIndexFieldNames(String,String,TStrings)

Populates a string list with the field names of an index in a table.

GetIndexFields(String)

Returns a DataTable object with the list of all the index Fields.

GetProcedureNames(TStrings)

Populates a string list with the names of stored procedures.

GetProviderFactory

Represents method GetProviderFactory.

GetSchema

Returns schema information for the data source of this Connection.

GetSchema(WideString)

Returns schema information for the data source of this Connection using the specified string for the schema name.

GetSchema(WideString,TArray)

Returns schema information for the data source of this DbConnection using the specified string for the schema name and the specified array for the restriction values.

GetSchema(WideString,_StringArray)

Returns schema information for the data source of this DbConnection using the specified string for the schema name and the specified string array for the restriction values.

GetSchemaTable(TDbCommand,TSchemaTableColumns,Integer)

Represents method GetSchemaTable(TDbCommand,TSchemaTableColumns,Integer).

GetTableNames(TStrings)

Populates a string list with the names of tables in a database.

HandleDisconnectCommands

Represents method HandleDisconnectCommands.

Loaded

Represents method Loaded.

Open

Opens a database connection with the settings specified by the ConnectionString.

Open(WideString,WideString)

Opens a database connection using the specified UserID and Password.

RegisterClient(TObject,TConnectChangeEvent)

Represents method RegisterClient(TObject,TConnectChangeEvent).

Rollback

Rolls back a transaction from a pending state.

SetConnectionString(WideString)

Represents method SetConnectionString(WideString).

SetDbParams(TDbConnectionStringBuilder)

Represents method SetDbParams(TDbConnectionStringBuilder).

SupportMultipleActiveResultSets

Represents method SupportMultipleActiveResultSets.

UnRegisterClient(TObject)

Represents method UnRegisterClient(TObject).

WaitForConnectComplete

Represents method WaitForConnectComplete.

OnStateChange

Occurs when the state of the event changes.