Components

<< Click to Display Table of Contents >>

Navigation:  ADONetVCL > Architecture >

Components

ADONetVCL includes 30+ Delphi non-visual components.  

 

 

collapsingSqlClient Data Access Components

 

Name

Description

SqlConnection

TSqlClientConnection

Lets you set up and control connections to SQL Server database.

SqlCommand

TSqlClientCommand

Executes a Transact-SQL statement or stored procedure against a SQL Server database.

Dataprovider

TSqlClientDataReader

Provides a way of reading a forward-only stream of rows from a SQL Server database.

SqlDataAdapter

TSqlClientDataAdapter

Lets you fill Virtual Table components with data and update a SQL Server database.

BulkCopy

TSqlClientBulkCopy

Lets you efficiently bulk load a SQL Server table with data from another source.

SqlQuery

TSqlClientQuery

Uses SQL statements to retrieve data from tables in a SQL Server database and pass it to one or more data-aware components through a TDataSource object.

This component provides a mechanism for updating data.

SqlTable

TSqlClientTable

Lets you retrieve and update data in a single table in a SQL Server database without writing SQL statements.

SqlStoredProc

TSqlClientStoredProc

Executes stored procedures and functions in a SQL Server database. Lets you edit cursor data returned as parameter.

 

 

collapsingOracleClient Data Access Components

 

Name

Description

Connection

TOracleClientConnection

Lets you set up and control connections to Oracle database.

Command

TOracleClientCommand

Executes a Transact-SQL statement or stored procedure against an Oracle database.

Dataprovider

TOracleClientDataReader

Provides a way of reading a forward-only stream of rows from an Oracle database.

DataAdapter

TOracleClientDataAdapter

Lets you fill Virtual Table components with data and update an Oracle database.

SqlQuery

TOracleClientQuery

Uses SQL statements to retrieve data from tables in an Oracle database and pass it to one or more data-aware components through a TDataSource object.

This component provides a mechanism for updating data.

SqlTable

TOracleClientTable

Lets you retrieve and update data in a single table in an Oracle database without writing SQL statements.

SqlStoredProc

TOracleClientStoredProc

Executes stored procedures and functions in an Oracle database. Lets you edit cursor data returned as parameter.

 

 

collapsingSQLite Data Access Components

 

Name

Description

SqlConnection

TSQLiteConnection

Lets you set up and control connections to SQLite database.

SqlCommand

TSQLiteCommand

Executes a Transact-SQL statement or stored procedure against a SQLite database.

Dataprovider

TSQLiteDataReader

Provides a way of reading a forward-only stream of rows from a SQLite database.

SqlDataAdapter

TSQLiteDataAdapter

Lets you fill Virtual Table components with data and update a SQLite database.

SqlQuery

TSQLiteQuery

Uses SQL statements to retrieve data from tables in a SQLite database and pass it to one or more data-aware components through a TDataSource object.

This component provides a mechanism for updating data.

SqlTable

TSQLiteTable

Lets you retrieve and update data in a single table in a SQLite database without writing SQL statements.

 

 

collapsingODBC Data Access Components

 

Name

Description

Connection

TOdbcConnection

Lets you set up and control connections to a data source through ODBC drivers.

Command

TOdbcCommand

Executes a Transact-SQL statement or stored procedure against a data source.

Dataprovider

TOdbcDataReader

Provides a way of reading a forward-only stream of rows from a data source.

DataAdapter

TOdbcDataAdapter

Lets you fill Virtual Table components with data and update a data source.

SqlQuery

TOdbcQuery

Uses SQL statements to retrieve data from tables in a data source and pass it to one or more data-aware components through a TDataSource object.

This component provides a mechanism for updating data.

SqlTable

TOdbcTable

Lets you retrieve and update data in a single table in a data source without writing SQL statements.

SqlStoredProc

TOdbcStoredProc

Executes stored procedures and functions in a data source. Lets you edit cursor data returned as parameter.

 

 

collapsingOLEDB Data Access Components

 

Name

Description

Connection

TOleDbConnection

Lets you set up and control connections to a data source through OLE DB provider.

Command

TOleDbCommand

Executes a Transact-SQL statement or stored procedure against a data source.

Dataprovider

TOleDbDataReader

Provides a way of reading a forward-only stream of rows from a data source.

DataAdapter

TOleDbDataAdapter

Lets you fill Virtual Table components with data and update a data source.

SqlQuery

TOleDbQuery

Uses SQL statements to retrieve data from tables in a data source and pass it to one or more data-aware components through a TDataSource object.

This component provides a mechanism for updating data.

SqlTable

TOleDbTable

Lets you retrieve and update data in a single table in a data source without writing SQL statements.

SqlStoredProc

TOleDbStoredProc

Executes stored procedures and functions in a data source. Lets you edit cursor data returned as parameter.

 

 

 

Reference

Architecture