DefaultSheetDataModel Constructor(DataTable)

In This Topic

Creates a default data model with the specified data table.

Syntax

Visual Basic
C#

'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.

Visual Basic

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;

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
Overload List
DataSource Property

Product Support Forum | Print this page