CodeGear RAD Studio provides a tool that enables communication between a data source and a dataset. You can use the Data Adapter Preview to specify what data to move into and out of the dataset either in the form of SQL statements or stored procedures that are invoked to read or write a database.

1. After you have dropped a BdpDataAdapter component onto the designer, click the Configure Data Adapter designer verb that appears at the bottom of the Object Inspector.
2. Click the Preview tab to display the Data Adapter Preview.
3. To limit the number of rows fetched, click the Limit rows check box.
4. Enter the number of rows you want the result set to contain, in the Rows to fetch text box.
5. Click Refresh to re-execute the query and to refill the list box with the new number of rows.