Binding to Databases

• Connecting to a Database Using Default Settings
• Displaying Selected Fields in Columns
• Customizing Headers for Bound Sheets
• Sizing Columns in Bound Sheets
• Assigning Cell Types for Bound Sheets
• Specifying Sheet and Database Interaction
• Using Virtual Mode with Bound Sheets

Overview

Using Visual Basic®, you can bind the Spread ActiveX controls to databases. When you bind the fpSpread control to a database, it automatically displays the data from the database in columns, where each field is assigned to a column and each row represents a record.

You can customize how the data from the database is displayed in the sheet, as well as how the fpSpread control interacts with a data control. If you are working with a large database, you can use virtual mode to save time and system resources.