Binds the model column with the data source column.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As IDataSourceSupport
Dim column As Integer
Dim columnName As String
instance.SetModelDataColumn(column, columnName) |
Parameters
- column
- Model column to be bounded
- columnName
- Data source column name of the column to which to bind
Example
This example binds the model column with the data source column.
| C# | Copy Code |
|---|
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 | Copy Code |
|---|
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 |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
