SetModelDataColumn(Int32,Int32) Method

Binds the model column to the specified data source column.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub SetModelDataColumn( _
   ByVal column As Integer, _
   ByVal value As Integer _
)

'Usage
 
Dim instance As DefaultSheetDataModel
Dim column As Integer
Dim value As Integer
 
instance.SetModelDataColumn(column, value)

public void SetModelDataColumn( 
   int column,
   int value
)

Parameters

column: Column index in the model
value: Data source column

Example

Visual Basic

Dim dt As New DataTable("Testing")
dt.Columns.Add("Number")
dt.Columns.Add("Letter")
dt.Rows.Add(New Object() {"1", "One"})
dt.Rows.Add(New Object() {"2", "Two"})
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(dt)
FpSpread1.ActiveSheet.Models.Data = dataModel
dataModel.SetModelDataColumn(0, 1)
dataModel.SetModelDataColumn(1, 0)

DataTable dt = new DataTable("Testing");
dt.Columns.Add("Number");
dt.Columns.Add("Letter");
dt.Rows.Add(new Object[]{"1", "One"});
dt.Rows.Add(new Object[] {"2", "Two"});
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(dt);
fpSpread1.ActiveSheet.Models.Data = dataModel;
dataModel.SetModelDataColumn(0, 1);
dataModel.SetModelDataColumn(1, 0);

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
Overload List