Spread Windows Forms 9.0 Product Documentation
MultiColumnComboBoxCellType Constructor(MultiColumnComboBoxCellType)
Example 


Specified multiple-column combo box cell type from which to copy
Creates a new copy from the specified cell type ("Copy constructor").
Syntax
'Declaration
 
Public Function New( _
   ByVal g As MultiColumnComboBoxCellType _
)
'Usage
 
Dim g As MultiColumnComboBoxCellType
 
Dim instance As New MultiColumnComboBoxCellType(g)
public MultiColumnComboBoxCellType( 
   MultiColumnComboBoxCellType g
)

Parameters

g
Specified multiple-column combo box cell type from which to copy
Example
This example creates a multiple column combo box cell.
DataSet ds = new DataSet();
DataTable emp = new DataTable("Employees");
DataTable div = 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 });

FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType mcb = new FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType();
mcb.DataSourceList = ds;           
fpSpread1.ActiveSheet.Cells[0, 0].CellType = mcb;
FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType mcb1 = new FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType(mcb);
fpSpread1.ActiveSheet.Cells[0, 1].CellType = mcb1;
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 mcb As New FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType()
mcb.DataSourceList = ds      
FpSpread1.ActiveSheet.Cells(0, 0).CellType = mcb
Dim mcb1 As New FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType(mcb)
FpSpread1.ActiveSheet.Cells(0, 1).CellType = mcb1
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

MultiColumnComboBoxCellType Class
MultiColumnComboBoxCellType Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.