DataSource Property (MultiColumnComboBoxCellType)

In This Topic

Gets or sets the data source for the list portion of the combo box.

Syntax

Visual Basic
C#

'Declaration
 
Public Property DataSource As Object

'Usage
 
Dim instance As MultiColumnComboBoxCellType
Dim value As Object
 
instance.DataSource = value
 
value = instance.DataSource

public object DataSource {get; set;}

Example

This example sets the DataSource property.

System.Data.DataSet ds = new System.Data.DataSet();
System.Data.DataTable emp = new System.Data.DataTable("Employees");
System.Data.DataTable div = new System.Data.DataTable("Division");
emp.Columns.Add("LastName");
emp.Columns.Add("FirstName");
emp.Rows.Add(new Object[] { "Jones", "Marianne" });
emp.Rows.Add(new Object[] { "Fieldes", "Anna" });
div.Columns.Add("Section");
div.Columns.Add("Specialty");
div.Rows.Add(new Object[] { "Finance", "Taxes" });
div.Rows.Add(new Object[] { "Mergers", "Legal" });
ds.Tables.AddRange(new System.Data.DataTable[] { emp, div });
FarPoint.Web.Spread.MultiColumnComboBoxCellType mccbct = new FarPoint.Web.Spread.MultiColumnComboBoxCellType();
mccbct.DataSource = ds;
mccbct.VerticalAlign = VerticalAlign.Top;
FpSpread1.ActiveSheetView.Cells[0, 0].CellType = mccbct;

VB.NET

Dim ds As New DataSet()
Dim emp As New DataTable("Employees")
Dim div As New DataTable("Division")
emp.Columns.Add("LastName")
emp.Columns.Add("FirstName")
emp.Rows.Add(New Object() {"Jones", "Marianne"})
emp.Rows.Add(New Object() {"Fieldes", "Anna"})
div.Columns.Add("Section")
div.Columns.Add("Specialty")
div.Rows.Add(New Object() {"Finance", "Taxes"})
div.Rows.Add(New Object() {"Mergers", "Legal"})
ds.Tables.AddRange(New DataTable() {emp, div})
Dim mccbct As New FarPoint.Web.Spread.MultiColumnComboBoxCellType
mccbct.DataSource = ds
mccbct.VerticalAlign = VerticalAlign.Top
FpSpread1.ActiveSheetView.Cells(0, 0).CellType = mccbct

Reference

MultiColumnComboBoxCellType Class
MultiColumnComboBoxCellType Members

Product Support Forum | Print this page