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:
- Double-click on the form to open the code window.
- Set the cell type for the UnitPrice column by adding the following code below the code you have already added:
- Save your project.
FarPoint.Win.Spread.CellType.CurrencyCellType CurrCell = new FarPoint.Win.Spread.CellType.CurrencyCellType(); CurrCell.DecimalPlaces = 2; fpSpread1.Sheets.Columns.CellType = CurrCell;
Dim CurrCell As New FarPoint.Win.Spread.CellType.CurrencyCellType() CurrCell.DecimalPlaces = 2 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.