DefaultSheetDataModel Constructor(DataSet)

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal dataSource As DataSet _
)

'Usage
 
Dim dataSource As DataSet
 
Dim instance As New DefaultSheetDataModel(dataSource)

public DefaultSheetDataModel( 
   DataSet dataSource
)

Parameters

dataSource: Data source to be used for this model

For more information about the DataSet class, see the Microsoft .NET Framework Reference.

This example creates a new default data model, binds it to a database in its constructor and attaches it to the DataModel of the active sheet.

Visual Basic

Dim conStr As String="Provider=Microsoft.JET.OLEDB.4.0;datasource=d:\\nwind.mdb"
Dim sqlStr As String="SELECT*FROM Employees"
Dim conn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(conStr)
Dim ds As DataSet= New DataSet()
Dim da As System.Data.OleDb.OleDbDataAdapter= New System.Data.OleDb.OleDbDataAdapter(sqlStr,conn)
da.Fill(ds,"Employees")
Dim dm As New FarPoint.Web.Spread.Model.DefaultSheetDataModel(ds)
FpSpread1.ActiveSheetView.DataModel=dm
FpSpread1.ActiveSheetView.OperationMode=FarPoint.Web.Spread.OperationMode.RowMode
dm.ActiveRow=2
conn.Close()

C#

string conStr="Provider=Microsoft.JET.OLEDB.4.0;datasource=d:\\nwind.mdb";
string sqlStr="SELECT*FROMEmployees";
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(conStr);
DataSet ds=new DataSet();
System.Data.OleDb.OleDbDataAdapter da= new System.Data.OleDb.OleDbDataAdapter(sqlStr,conn);
da.Fill(ds,"Employees");
FarPoint.Web.Spread.Model.DefaultSheetDataModel dm = new FarPoint.Web.Spread.Model.DefaultSheetDataModel(ds);
FpSpread1.ActiveSheetView.DataModel=dm;
FpSpread1.ActiveSheetView.OperationMode=FarPoint.Web.Spread.OperationMode.RowMode;
dm.ActiveRow=2;
conn.Close();

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

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
Overload List
DataSource Property