In this step, you will change the cell type for one of the columns to better display the data from the database.

Run your project and you should see a form that looks similar to the following:

1. Double-click on the form to open the code window.
2. Set the cell type for the UnitPrice column by adding the code in the following example after the code you have already added:
3. Save your project.

Example

FarPoint.Win.Spread.CellType.CurrencyCellType CurrCell = new FarPoint.Win.Spread.CellType.CurrencyCellType();
CurrCell.DecimalPlaces = 2;
CurrCell.CurrencySymbol = "US$";
fpSpread1.Sheets[0].Columns[3].CellType = CurrCell;

Dim CurrCell As New FarPoint.Win.Spread.CellType.CurrencyCellType()
CurrCell.DecimalPlaces = 2
CurrCell.CurrencySymbol = "US$"
FpSpread1.Sheets(0).Columns(3).CellType = CurrCell

You have managed data binding to a corporate database using Spread. You have completed this tutorial.

Review the list of steps for Tutorial: Binding to a Corporate Database (Older Visual Studio).

Copyright © GrapeCity, inc. All rights reserved.