Adding an Unbound Row

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

Return to the overview Managing Data Binding.

Using a ShortCut

Bind the data.
Use the AddUnboundRows method after adding any data to the data set.
Use the AddRowToDataSource if needed.

Example

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

C#	Copy Code
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); }

Copy Code

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);
}

VB	Copy Code
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

Copy Code

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