Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetDataModel Class / DefaultSheetDataModel Constructor / DefaultSheetDataModel Constructor(DataTable)
Data source to be used for this model
Example


In This Topic
    DefaultSheetDataModel Constructor(DataTable)
    In This Topic
    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;
    See Also