FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class : AddUnboundRows Method |
'Usage Dim instance As DefaultSheetDataModel Dim row As Integer Dim count As Integer instance.AddUnboundRows(row, count)
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)
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6