FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : AddUnboundRows Method |
This creates a row of blank cells that is not bound to the data set and does not affect the data set. An unbound row does not inherently appear or behave differently from bound rows.
The unbound row is added to the models using the IUnboundRowSupport interface.
If you subsequently need to add an unbound row to the bound data set, use AddRowToDataSource method.
For more information, refer to Adding an Unbound Row.
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); }
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
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
SheetView Class
SheetView Members
AddRowToDataSource Method
IUnboundRowSupport Interface