Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / IDataSourceSupport Interface / SetModelDataColumn Method
Model column to be bound
Data source column name of the column to which to bind
Example


In This Topic
    SetModelDataColumn Method (IDataSourceSupport)
    In This Topic
    Binds the model column with the data source column.
    Syntax
    '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
    Example
    This example binds the model to a data set.
    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"); 
    
    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")
    
    See Also