Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.CellType Namespace / MultiColumnComboBoxCellType Class / DataColumn Property
Example


In This Topic
    DataColumn Property
    In This Topic
    Gets or sets which list column (by index) serves as the data portion of the combo box.
    Syntax
    'Declaration
     
    Public Property DataColumn As Integer
    'Usage
     
    Dim instance As MultiColumnComboBoxCellType
    Dim value As Integer
     
    instance.DataColumn = value
     
    value = instance.DataColumn
    public int DataColumn {get; set;}

    Property Value

    Integer list column index
    Example
    This example creates a cell of this type, sets properties of this cell type, and assigns this cell type to a cell.
    FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType mcb = new FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType();
    mcb.BackgroundImage = null;
    mcb.DataSourceList = ds;
    mcb.DataColumn = 2;
    mcb.ColumnEdit = 2;
    mcb.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows;
    mcb.ButtonAlign = FarPoint.Win.ButtonAlign.Left;
    mcb.ListAlignment = FarPoint.Win.ListAlignment.Right;
    mcb.ListWidth = 500;
    mcb.ListOffset = 5;
    mcb.MaxDrop = 5;
    mcb.StringTrim = StringTrimming.EllipsisCharacter;
    mcb.SubEditor = null;
    fpSpread1.ActiveSheet.Cells[0, 0].CellType = mcb;
    
    Dim mcb As New FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType()
    mcb.BackgroundImage = Nothing
    mcb.DataSourceList = ds
    mcb.DataColumn = 2
    mcb.ColumnEdit = 2
    mcb.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows
    mcb.ButtonAlign = FarPoint.Win.ButtonAlign.Left
    mcb.ListAlignment = FarPoint.Win.ListAlignment.Right
    mcb.ListWidth = 500
    mcb.ListOffset = 5
    mcb.MaxDrop = 5
    mcb.StringTrim = StringTrimming.EllipsisCharacter
    mcb.SubEditor = Nothing
    FpSpread1.ActiveSheet.Cells(0, 0).CellType = mcb
    See Also