Spread for ASP.NET 11 Product Documentation
DataSource Property (MultiColumnComboBoxCellType)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > MultiColumnComboBoxCellType Class : DataSource Property
Gets or sets the data source for the list portion of the combo box.
Syntax
'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;
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
See Also

Reference

MultiColumnComboBoxCellType Class
MultiColumnComboBoxCellType Members