AddUnboundRows Method (DefaultSheetDataModel)

Visual Basic
C#

'Declaration
 
Public Sub AddUnboundRows( _
   ByVal row As Integer, _
   ByVal count As Integer _
)

'Usage
 
Dim instance As DefaultSheetDataModel
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 add the new rows
count: Number of rows to add

This example adds an unbound row to the sheet, then adds that row to the data source.

C#

FarPoint.Web.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Web.Spread.Model.DefaultSheetDataModel(); 
DataSet ds = new DataSet(); 
DataTable name; 
name = ds.Tables.Add("Name"); 
name.Columns.Add("FirstName", Type.GetType("System.String")); 
name.Columns.Add("LastName", Type.GetType("System.String")); 
name.Rows.Add(new object[] {"John", "Doe"}); 
name.Rows.Add(new object[] {"Sally ", "Jones"}); 
name.Rows.Add(new object[] {"Terry", "Hernandez"}); 
FpSpread1.ActiveSheetView.DataModel = dataModel; 
dataModel.DataSource = ds; 
dataModel.AddUnboundRows(1, 2); 
name.Rows.Add(new object[] {"Jane", "Simpson"}); 
dataModel.AddRowToDataSource(2, false);

Visual Basic

Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel
Dim ds As New DataSet
Dim name As DataTable
name = ds.Tables.Add("Name")
name.Columns.Add("FirstName", Type.GetType("System.String"))
name.Columns.Add("LastName", Type.GetType("System.String"))
name.Rows.Add(New Object() {"John", "Doe"})
name.Rows.Add(New Object() {"Sally ", "Jones"})
name.Rows.Add(New Object() {"Terry", "Hernandez"})
FpSpread1.ActiveSheetView.DataModel = dataModel
dataModel.DataSource = ds
dataModel.AddUnboundRows(1, 2)
name.Rows.Add(New Object() {"Jane", "Simpson"})
dataModel.AddRowToDataSource(2, False)

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

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members