SetModelDataColumn Method (IDataSourceSupport)

Visual Basic
C#

'Declaration
 
Sub SetModelDataColumn( _
   ByVal column As Integer, _
   ByVal columnName As String _
)

'Usage
 
Dim instance As IDataSourceSupport
Dim column As Integer
Dim columnName As String
 
instance.SetModelDataColumn(column, columnName)

void SetModelDataColumn( 
   int column,
   string columnName
)

Parameters

column: Model column to be bound
columnName: Data source column name of the column to which to bind

This example binds the model column with the data source column.

C#

FarPoint.Win.Spread.Model.IDataSourceSupport dss;
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"});
dss = (FarPoint.Win.Spread.Model.IDataSourceSupport)fpSpread1.ActiveSheet.Models.Data;
dss.DataSource = dt;
dss.SetModelDataColumn(0, "Letter");
dss.SetModelDataColumn(1, "Number");
fpSpread1.ActiveSheet.Models.Data = (FarPoint.Win.Spread.Model.ISheetDataModel)dss;

Visual Basic

Dim dss As FarPoint.Win.Spread.Model.IDataSourceSupport
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"})
dss = FpSpread1.ActiveSheet.Models.Data
dss.DataSource = dt
dss.SetModelDataColumn(0, "Letter")
dss.SetModelDataColumn(1, "Number")
FpSpread1.ActiveSheet.Models.Data = dss

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

Reference

IDataSourceSupport Interface
IDataSourceSupport Members