AddRowToDataSource Method (SheetView)

Visual Basic
C#

'Declaration
 
Public Sub AddRowToDataSource( _
   ByVal row As Integer, _
   ByVal autoFillData As Boolean _
)

'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim autoFillData As Boolean
 
instance.AddRowToDataSource(row, autoFillData)

public void AddRowToDataSource( 
   int row,
   bool autoFillData
)

Parameters

row: Row index at which to add row
autoFillData: Whether to automatically fill the row with data

This example adds a row to the data source.

C#

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

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 Class
SheetView Members

User-Task Documentation

Adding an Unbound Row