Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / AddRowToDataSource Method
Row index at which to add row
Whether to automatically fill the row with data
Example


In This Topic
    AddRowToDataSource Method (SheetView)
    In This Topic
    Adds the unbound row to the data source.
    Syntax
    '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
    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
    See Also