Spread Windows Forms 7.0 Product Documentation
Adding an Unbound Column to a Bound Sheet
See Also Support Options
Spread Windows Forms 7.0 Product Documentation > Developer's Guide > Managing Data Binding > Adding to Bound Data > Adding an Unbound Column to a Bound Sheet

Glossary Item Box

Once you bind a sheet to a data set you might want to add an unbound column to contain additional data.

The following figure shows a sheet in a Spread component that contains data from a data set and an unbound row at the bottom that calculates the averages.

Sheet with unbound row

You can add an unbound column to the Spread control by increasing the ColumnCount property after the control is bound. Another option is to use the DataField property to bind specific columns and leave DataField unset for the columns you do not want to bind.

Using Code

  1. Create your data set.
  2. Set the FpSpread or Sheet DataSource property equal to the data set.
  3. Set the ColumnCount property for the sheet.

Example

This example code binds the Spread component to a data set and then sets the column count.

C# Copy Code
// Bind the component to the data set.
fpSpread1.DataSource = dbDataSet;
// If this datasource has 19 columns, set the count to 20.
fpSpread1.Sheets[0].ColumnCount=20;
VB Copy Code
' Bind the component to the data set.
FpSpread1.DataSource = dbDataSet
' If this datasource has 19 columns, set the count to 20.
FpSpread1.Sheets(0).ColumnCount=20

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.