ActiveX

To bind an fpSpread ActiveX control to a database using default fpSpread control settings

1. Add the Microsoft ADO Data Control 6.0 (OLEDB) to your project.
2. Create a Microsoft ADO Data Control 6.0 (OLEDB) on the form.
3. Right-click on the Data control, and choose ADODC Properties from the pop-up menu.
4. In the Property Pages, on the General property page, under Source of Connection,
   1. Choose the Use Connection String option button.
   2. Choose the Build button.
5. In the Data Link Properties dialog,
   1. On the Provider tab,
      1. Select Microsoft Jet 4.0 OLE DB Provider from the list of available providers.
      2. Choose the Next button.
   2. On the Connection tab,
      1. Under item 1 on the tab, provide the database name to connect to either by typing it in the field or by pressing the ellipses button and selecting the database using the Select Access Database dialog.
      2. Under item 2 on the tab, if necessary, enter the user information required to log on to the database.
      3. Choose the Test Connection button.
      4. If the connection succeeded, select OK in the message box. If the connection did not succeed, repeat steps 5.b.i through 5.b.iii.
   3. Choose OK to continue and close the Data Link Properties dialog.
6. In the Property Pages, your connection string has been created in the Use Connection String text box.
   You can use your connection string at run time to access this database connection.
7. In the Property Pages, choose the RecordSource page.
   1. On the RecordSource page, under RecordSource, from the CommandType drop-down list box choose 2 - adCmdTable.
   2. From the Table or Stored Procedure Name drop-down list box, choose the database table to which you want to connect.
   3. Choose the OK button.
8. Add the FarPoint Spreadsheet ADO Control (OLEDB) to your project.
9. Create an fpSpread control on the form.
10. Set the DataSource property to the name of the Microsoft ADO Data Control 6.0 (OLEDB). If you wish to bind a specific sheet, then set the Sheet and DataSource properties at run time.