Data Binding

Using the ActiveX controls, you can bind the fpSpread control using ActiveX Data Object (ADO) to display database records. Many sheet characteristics can be set automatically when the database is read by the fpSpread control, including column header text, column size, and cell type. Alternatively, you can tailor these and other characteristics to meet your needs, including optimizing performance using virtual mode.

The following figure illustrates an fpSpread control bound to a database. The fpSpread control has automatically configured itself to display the database records.

For more information about data binding, see Binding to Databases.