FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread.Model 名前空間 > DefaultSheetDataModel クラス : DataMember プロパティ |
'Declaration Public Property DataMember As String
'使用法 Dim instance As DefaultSheetDataModel Dim value As String instance.DataMember = value value = instance.DataMember
public string DataMember {get; set;}
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 ds As New DataSet Dim emp As New DataTable("Employees") Dim div As 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}) Dim dataModel As 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")