Spread Windows Forms 8.0 Product Documentation
SetModelDataColumn(Int32,String) Method
Example 


Index of column in the model
Name of the data source column
Binds a model column to a specified data source column.
Syntax
'Declaration
 
Public Overloads Sub SetModelDataColumn( _
   ByVal column As Integer, _
   ByVal columnName As String _
) 
'Usage
 
Dim instance As DefaultSheetDataModel
Dim column As Integer
Dim columnName As String
 
instance.SetModelDataColumn(column, columnName)
public void SetModelDataColumn( 
   int column,
   string columnName
)

Parameters

column
Index of column in the model
columnName
Name of the data source column
Example
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"})
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(dt)
FpSpread1.ActiveSheet.Models.Data = dataModel
dataModel.SetModelDataColumn(0, "Letter")
dataModel.SetModelDataColumn(1, "Number")
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"});
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(dt);
fpSpread1.ActiveSheet.Models.Data = dataModel;
dataModel.SetModelDataColumn(0, "Letter");
dataModel.SetModelDataColumn(1, "Number");
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

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.