Spread for ASP.NET 11 Product Documentation
AddRowToDataSource Method (DefaultSheetDataModel)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class : AddRowToDataSource Method
Row index at which to add a row
Whether to automatically fill the row with data
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 an unbound row to the sheet, then adds that row to the data source.
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);
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)
See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members