FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class > DefaultSheetDataModel Constructor : DefaultSheetDataModel Constructor(DataSet) |
'Declaration Public Function New( _ ByVal dataSource As DataSet _ )
'Usage Dim dataSource As DataSet Dim instance As New DefaultSheetDataModel(dataSource)
public DefaultSheetDataModel( DataSet dataSource )
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()
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 Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6