PowerTools SPREAD for Windows Forms 10.0J
DataSource プロパティ (DefaultSheetDataModel)


データソースを取得または設定します。
構文
'Declaration
 
Public Property DataSource As Object
'使用法
 
Dim instance As DefaultSheetDataModel
Dim value As Object
 
instance.DataSource = value
 
value = instance.DataSource
public object DataSource {get; set;}

プロパティ値

データソースを含むObject
例外
例外説明
System.ArgumentExceptionデータソースが空です。
次のサンプルコードは、データソースに行を追加します。
DataSet ds = new DataSet();
DataTable emp = new DataTable("Employees");
DataTable div = new DataTable("Division");
emp.Columns.Add("LastName");
emp.Columns.Add("FirstName");
emp.Rows.Add(new Object[] {"Jones", "Marianne"});
emp.Rows.Add(new Object[] {"Fieldes", "Anna"});
div.Columns.Add("Section");
div.Columns.Add("Specialty");
div.Rows.Add(new Object[] {"Finance", "Taxes"});
div.Rows.Add(new Object[] {"Mergers", "Legal"});
ds.Tables.AddRange(new DataTable[] {emp, div});

new FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel();
dataModel.DataSource = ds;
dataModel.DataMember = "Employees";
dataModel.AddUnboundRows(1, 3);
fpSpread1.ActiveSheet.Models.Data = dataModel;
dataModel.AddRowToDataSource(1, true);
dataModel.SetValue(1, 0, "Kingsley");
dataModel.SetValue(1, 1, "Mark");
Dim ex As FarPoint.CalcEngine.Expression
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(10, 10)
dataModel.AddCustomName("TWICESUM", New FarPoint.CalcEngine.DoubleExpression(10))
dataModel.SetFormula(1, 1, "TWICESUM")
FpSpread1.ActiveSheet.Models.Data = dataModel
ex = dataModel.GetExpression(1, 1)
dataModel.EvaluateExpression(1, 1, ex)
MessageBox.Show("The expression is " & ex.ToString())
参照

DefaultSheetDataModel クラス
DefaultSheetDataModel メンバ

 

 


© 2004-2017, GrapeCity inc. All rights reserved.