Spread for ASP.NET 9.0 Product Documentation
AddUnboundRows Method (SheetView)
Example 


Row index at which to start adding rows
Number of rows to add
Adds unbound rows to the data model.
Syntax
'Declaration
 
Public Sub AddUnboundRows( _
   ByVal row As Integer, _
   ByVal count As Integer _
) 
'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim count As Integer
 
instance.AddUnboundRows(row, count)
public void AddUnboundRows( 
   int row,
   int count
)

Parameters

row
Row index at which to start adding rows
count
Number of rows to add
Remarks

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.

Example
This example adds a row to the data source.
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
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

SheetView Class
SheetView Members
AddRowToDataSource Method
IUnboundRowSupport Interface

User-Task Documentation

Adding an Unbound Row

 

 


Copyright © GrapeCity, inc. All rights reserved.