DataMember Property (DefaultSheetDataModel)

Visual Basic
C#

'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

This example adds the row to the data source.

C#

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");

Visual Basic

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")

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

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members