# Adding an Unbound Column to a Bound Sheet

Learn how to add an unbound column to a bound sheet with Spread.NET's ColumnCount property and DataField property

## Content

Once you bind a sheet to a data set you might want to add an unbound column to contain additional data.
You can add an unbound column to the Spread control by increasing the [ColumnCount](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.ColumnCount.html) property after the control is bound. Another option is to use the [DataField](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Column.DataField.html) property to bind specific columns and leave the [DataField](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Column.DataField.html) property unset for the columns you do not want to bind.

## Using Code

1. Create your data set.
2. Set the **FpSpread** object's or **Sheet** object's [DataSource](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.DataSource.html) property equal to the data set.
3. Set the [ColumnCount](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.ColumnCount.html) property for the sheet.

## Example

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

```csharp
// 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;
```

```vbnet
' 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

[Customizing Column and Field Binding](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-data-binding/spwin-databind-custom/spwin-databind-field)
[Customizing Cell Types for Bound Sheets](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-data-binding/spwin-databind-custom/spwin-databind-celltypes)
[Customizing Column Headers for Bound Sheets](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-data-binding/spwin-databind-custom/spwin-databind-colheaders)