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 to a data set.

C#

FarPoint.Web.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.Web.Spread.Model.IDataSourceSupport)FpSpread1.ActiveSheetView.DataModel; 
dss.DataSource = dt; 
dss.SetModelDataColumn(0, "Letter"); 
dss.SetModelDataColumn(1, "Number");

Visual Basic

Dim dss As FarPoint.Web.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.ActiveSheetView.DataModel
dss.DataSource = dt
dss.SetModelDataColumn(0, "Letter")
dss.SetModelDataColumn(1, "Number")

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

IDataSourceSupport Interface
IDataSourceSupport Members