Creates a default data model with the specified data set.
Syntax
Parameters
- dataSource
- Data source to be used for this model
Remarks
Example
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 |  Copy Code |
|---|
DimconStrAsString="Provider=Microsoft.JET.OLEDB.4.0;datasource=d:\\nwind.mdb"
DimsqlStrAsString="SELECT*FROMEmployees"
DimconnAsSystem.Data.OleDb.OleDbConnection=NewSystem.Data.OleDb.OleDbConnection(conStr)
DimdsAsDataSet=NewDataSet()
DimdaAsSystem.Data.OleDb.OleDbDataAdapter=NewSystem.Data.OleDb.OleDbDataAdapter(sqlStr,conn)
da.Fill(ds,"Employees")
DimdmAsNewFarPoint.Web.Spread.Model.DefaultSheetDataModel(ds)
FpSpread1.ActiveSheetView.DataModel=dm
FpSpread1.ActiveSheetView.OperationMode=FarPoint.Web.Spread.OperationMode.RowMode
dm.ActiveRow=2
conn.Close() |
| C# | Copy Code |
|---|
stringconStr="Provider=Microsoft.JET.OLEDB.4.0;datasource=d:\\nwind.mdb";
stringsqlStr="SELECT*FROMEmployees";
System.Data.OleDb.OleDbConnectionconn=newSystem.Data.OleDb.OleDbConnection(conStr);
DataSetds=newDataSet();
System.Data.OleDb.OleDbDataAdapterda=newSystem.Data.OleDb.OleDbDataAdapter(sqlStr,conn);
da.Fill(ds,"Employees");
FarPoint.Web.Spread.Model.DefaultSheetDataModeldm=newFarPoint.Web.Spread.Model.DefaultSheetDataModel(ds);
FpSpread1.ActiveSheetView.DataModel=dm;
FpSpread1.ActiveSheetView.OperationMode=FarPoint.Web.Spread.OperationMode.RowMode;
dm.ActiveRow=2;
conn.Close(); |
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
