Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / DefaultSheetDataModel Class / AddRowToDataSource Method
Row index at which to add a row
Whether to automatically fill the row with data
Example


In This Topic
    AddRowToDataSource Method (DefaultSheetDataModel)
    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 DefaultSheetDataModel
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 a row
    autoFillData
    Whether to automatically fill the row with data
    Example
    This example adds the row to the data source. 
    DataSet ds = new DataSet();
DataTable emp = new DataTable("Employees");
DataTable div = new DataTable("Division");
emp.Columns.Add("LastName");
emp.Columns.Add("FirstName");
emp.Rows.Add(new Object[] {"Jones", "Marianne"});
emp.Rows.Add(new Object[] {"Fieldes", "Anna"});
div.Columns.Add("Section");
div.Columns.Add("Specialty");
div.Rows.Add(new Object[] {"Finance", "Taxes"});
div.Rows.Add(new Object[] {"Mergers", "Legal"});
ds.Tables.AddRange(new DataTable[] {emp, div});

new FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel();
dataModel.DataSource = ds;
dataModel.DataMember = "Employees";
dataModel.AddUnboundRows(1, 3);
fpSpread1.ActiveSheet.Models.Data = dataModel;
dataModel.AddRowToDataSource(1, true);
dataModel.SetValue(1, 0, "Kingsley");
dataModel.SetValue(1, 1, "Mark");

    Dim ds As New DataSet
Dim emp As New DataTable("Employees")
Dim div As New DataTable("Division")
emp.Columns.Add("LastName")
emp.Columns.Add("FirstName")
emp.Rows.Add(New Object() {"Jones", "Marianne"})
emp.Rows.Add(New Object() {"Fieldes", "Anna"})
div.Columns.Add("Section")
div.Columns.Add("Specialty")
div.Rows.Add(New Object() {"Finance", "Taxes"})
div.Rows.Add(New Object() {"Mergers", "Legal"})
ds.Tables.AddRange(New DataTable() {emp, div})

Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel
dataModel.DataSource = ds
dataModel.DataMember = "Employees"
dataModel.AddUnboundRows(1, 3)
FpSpread1.ActiveSheet.Models.Data = dataModel

dataModel.AddRowToDataSource(1, True)
dataModel.SetValue(1, 0, "Kingsley")
dataModel.SetValue(1, 1, "Mark")
    See Also

    Reference

    DefaultSheetDataModel Class
    DefaultSheetDataModel Members

     

     

    Copyright © 2003-2020 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page