Spread Windows Forms 7.0 Product Documentation
GetModelColumnFromDataColumn Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > IDataSourceSupport Interface : GetModelColumnFromDataColumn Method


column
Data source column index to be converted

Glossary Item Box

Converts the data source column index to the model column index.

Syntax

Visual Basic (Declaration) 
Function GetModelColumnFromDataColumn( _
   ByVal column As Integer _
) As Integer
Visual Basic (Usage)Copy Code
Dim instance As IDataSourceSupport
Dim column As Integer
Dim value As Integer
 
value = instance.GetModelColumnFromDataColumn(column)
C# 
int GetModelColumnFromDataColumn( 
   int column
)

Parameters

column
Data source column index to be converted

Return Value

Integer index of model column

Example

This example converts the data source column index to the model column index.
C#Copy Code
FarPoint.Win.Spread.Model.IDataSourceSupport dss ;
DataTable dt = new DataTable("Testing");
int i;
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;
fpSpread1.DataSource = dt;
i = dss.GetModelColumnFromDataColumn(1);
label1.Text = "The model column index is " + i.ToString();
Visual BasicCopy Code
Dim dss As FarPoint.Win.Spread.Model.IDataSourceSupport
Dim dt As New DataTable("Testing")
Dim i As Integer
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
FpSpread1.DataSource = dt
i = dss.GetModelColumnFromDataColumn(1)
Label1.Text = "The model column index is " & i.ToString()

Requirements

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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.