Adds unbound rows to the data model.
            
            
            
Syntax
            Parameters
- row
 
- Row index at which to add the new rows
 - count
 
- Number of rows to add
 
            
             
            
						
            
            
            
            
Example
This example adds an unbound row to the sheet, then adds that row to the data source.
             
| C# |  Copy Code | 
|---|
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 |  Copy Code | 
|---|
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) | 
 
 
            
            
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
 
            
            
See Also