Visual Basic (Declaration) | |
---|---|
Public Sub AddUnboundRows( _ ByVal row As Integer, _ ByVal count As Integer _ ) |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As SheetView Dim row As Integer Dim count As Integer instance.AddUnboundRows(row, count) |
Parameters
- row
- Row index at which to start adding rows
- count
- Number of rows to add
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.
This example adds a 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); } |
Visual Basic | 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 |
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
Reference
SheetView ClassSheetView Members
AddRowToDataSource Method
IUnboundRowSupport Interface