Spread for ASP.NET 9.0 Product Documentation
DefaultSheetDataModel Constructor(DataTable)
Example 


Data source to be used for this model
Creates a default data model with the specified data table.
Syntax
'Declaration
 
Public Function New( _
   ByVal dataSource As DataTable _
)
'Usage
 
Dim dataSource As DataTable
 
Dim instance As New DefaultSheetDataModel(dataSource)
public DefaultSheetDataModel( 
   DataTable dataSource
)

Parameters

dataSource
Data source to be used for this model
Remarks
For more information about the DataTable class, see the Microsoft .NET Framework Reference.
Example
This example creates a new default data model, binds it to a DataTable in its constructor and attaches it to the DataModel of the active sheet.
Dim dt As New DataTable("FarPoint")
dt.Columns.Add("Product")
dt.Rows.Add(New Object(){"SpreadWebv2"})
dt.Rows.Add(New Object(){"InputProforWinForms"})
Dim dm As New FarPoint.Web.Spread.Model.DefaultSheetDataModel(dt)
FpSpread1.ActiveSheetView.DataModel=dm
FpSpread1.ActiveSheetView.Columns(0).Width=240
DataTable dt = new DataTable("FarPoint");
dt.Columns.Add("Product");
dt.Rows.Add(new object[]{"SpreadWebv2"});
dt.Rows.Add(new object[]{"InputProforWinForms"});
FarPoint.Web.Spread.Model.DefaultSheetDataModel dm = new FarPoint.Web.Spread.Model.DefaultSheetDataModel(dt);
FpSpread1.ActiveSheetView.DataModel=dm;
FpSpread1.ActiveSheetView.Columns[0].Width=240;
Requirements

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

See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
Overload List
DataSource Property

 

 


Copyright © GrapeCity, inc. All rights reserved.