Spread Windows Forms 9.0 Product Documentation
DataMember Property (DefaultSheetDataModel)
Example 


Gets or sets the data member (table name) to use for data.
Syntax
'Declaration
 
Public Property DataMember As String
'Usage
 
Dim instance As DefaultSheetDataModel
Dim value As String
 
instance.DataMember = value
 
value = instance.DataMember
public string DataMember {get; set;}

Property Value

String containing the name of the data member
Example
This example adds the row to the data source.
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")
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.