# Adding an Unbound Row

Spread for ASP.NET allows you to add an unbound row of cells to a spreadsheet that is bound to a data source.

## Content

You can add an unbound row of cells to a sheet in a component that is bound to a data source.

## Using a ShortCut

1. Bind the data.
2. Use the [AddUnboundRows](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.AddUnboundRows.html) method after adding any data to the data set.
3. Use the [AddRowToDataSource](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.AddRowToDataSource.html) method to add the row to the data source.

## Example

This example code adds an unbound row, adds data to the row, and then adds the row to the data source.

```csharp
private void FpSpread1ChildViewCreated(object sender, FarPoint.Web.Spread.CreateChildViewEventArgs e)
{
FarPoint.Web.Spread.SheetView sv;
sv = e.SheetView;
sv.AddUnboundRows(0, 1);
sv.Cells[0, 0].Value = "Dallas";
sv.Cells[0, 1].Value = "0";
sv.Cells[0, 2].Value = "Texas";
sv.AddRowToDataSource(0, true);
}
```

```vbnet
Private Sub FpSpread1ChildViewCreated(ByVal sender As Object, ByVal e As FarPoint.Web.Spread.CreateChildViewEventArgs) Handles FpSpread1.ChildViewCreated
Dim sv As FarPoint.Web.Spread.SheetView
sv = e.SheetView
sv.AddUnboundRows(0, 1)
sv.Cells(0, 0).Value = "Dallas"
sv.Cells(0, 1).Value = "0"
sv.Cells(0, 2).Value = "Texas"
sv.AddRowToDataSource(0, True)
End Sub
```

## See Also

[Displaying Data as a Hierarchy](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-databound/spweb-dbhierarchy)