SDAC Component List

Lets you set up and control connections to SQL Server.

Uses SQL statements to retrieve data from SQL Server table or tables and supply it to one or more data-aware components through a TDataSource component. Provides flexible update of data.

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

Executes stored procedures and functions.

Executes SQL statements and stored procedures that do not return rowsets.

Executes sequences of SQL statements.

Lets you tune update operations for DataSet component.

Provides an interface between a SDAC dataset components and data-aware controls on a form.

Interface for monitoring dynamic SQL execution in SDAC-based applications.

Is used on client side to supply username, password, database and server name.

Allows working with user-defined table types in SQL Server 2008.

Provides dataset functionality for data that has no real database connection. This component is placed on the Data Access page of the Component palette, not on the SQL Server Access page.

Provides quick data loading to SQL Server database.

Serves to store a database or its parts as a script and also to restore database from received script.

Lets you send and receive messages using the SQL Server 2005 Service Broker system.

Retrieves embracing metadata on specified SQL object.

Lets you react on different server side changes on-the-fly. Based on the Query Notifications mechanism of SQL Server 2005.

Lets you control distributed transactions via Microsoft Distributed Transaction Coordinator.

Lets you set up and control connections to SQL Server Compact Edition.

Transfers data between all types of TDataSets descendants. This component is placed on the Data Access page of the Component palette, not on the SQL Server Access page.