Spread ASP.NET 6.0 Product Documentation
DefaultSheetDataModel Constructor(DataTable)
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class > DefaultSheetDataModel Constructor : DefaultSheetDataModel Constructor(DataTable)


dataSource
Data source to be used for this model

Glossary Item Box

Creates a default data model with the specified data table.

Syntax

Visual Basic (Declaration) 
Public Function New( _
   ByVal dataSource As DataTable _
)
Visual Basic (Usage)Copy Code
Dim dataSource As DataTable
 
Dim instance As New DefaultSheetDataModel(dataSource)
C# 
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.
Visual BasicCopy Code
DimdtAsNewDataTable("FarPoint")
dt.Columns.Add("Product")
dt.Rows.Add(NewObject(){"SpreadWebv2"})
dt.Rows.Add(NewObject(){"InputProforWinForms"})
DimdmAsNewFarPoint.Web.Spread.Model.DefaultSheetDataModel(dt)
FpSpread1.ActiveSheetView.DataModel=dm
FpSpread1.ActiveSheetView.Columns(0).Width=240
C#Copy Code
DataTabledt=newDataTable("FarPoint");
dt.Columns.Add("Product");
dt.Rows.Add(newobject[]{"SpreadWebv2"});
dt.Rows.Add(newobject[]{"InputProforWinForms"});
FarPoint.Web.Spread.Model.DefaultSheetDataModeldm=newFarPoint.Web.Spread.Model.DefaultSheetDataModel(dt);
FpSpread1.ActiveSheetView.DataModel=dm;
FpSpread1.ActiveSheetView.Columns[0].Width=240;

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

© 2002-2012 GrapeCity, Inc. All Rights Reserved.