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


In This Topic
    DataSourceList Property
    In This Topic
    Gets or sets the data source for the list portion of the combo box.
    Syntax
    'Declaration
     
    Public Property DataSourceList As Object
    'Usage
     
    Dim instance As MultiColumnComboBoxCellType
    Dim value As Object
     
    instance.DataSourceList = value
     
    value = instance.DataSourceList
    public object DataSourceList {get; set;}

    Property Value

    Object containing the data source for the list portion
    Example
    This example creates a multiple column combo box cell, sets the data source and other properties, 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