Spread Windows Forms 7.0 Product Documentation
AddRowToDataSource Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel Class : AddRowToDataSource Method


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

Glossary Item Box

Adds the unbound row to the data source.

Syntax

Visual Basic (Declaration) 
Public Sub AddRowToDataSource( _
   ByVal row As Integer, _
   ByVal autoFillData As Boolean _
) 
Visual Basic (Usage)Copy Code
Dim instance As DefaultSheetDataModel
Dim row As Integer
Dim autoFillData As Boolean
 
instance.AddRowToDataSource(row, autoFillData)
C# 
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.
C#Copy Code
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");
Visual BasicCopy Code
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")

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.