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 bound
- 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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also
