Spread Windows Forms 7.0 Product Documentation
DataMemberList Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > MultiColumnComboBoxCellType Class : DataMemberList Property


Glossary Item Box

Gets or sets the name of the data member that populates the list in the list portion of the combo box.

Syntax

Visual Basic (Declaration) 
Public Property DataMemberList As String
Visual Basic (Usage)Copy Code
Dim instance As MultiColumnComboBoxCellType
Dim value As String
 
instance.DataMemberList = value
 
value = instance.DataMemberList
C# 
public string DataMemberList {get; set;}

Property Value

String containing the list of data members

Example

This example creates a multiple column combo box cell, sets the data source and member list, and assigns this cell type to a cell.
C#Copy Code
string conStr = "Provider=Microsoft.JET.OLEDB.4.0;data source= D:\\Patients2000.mdb"; 
string sqlStr = "SELECT * FROM Patients"; 
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(conStr); 
DataSet ds = new DataSet(); 
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sqlStr, conn); 
da.Fill(ds); 
FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType mc = new FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType();

mc.DataSourceList = ds; 
mc.DataMemberList = "Patients"; 
fpSpread1.ActiveSheet.Cells[0, 0].CellType = mc;
 
Visual BasicCopy Code
Dim conStr As String = "Provider=Microsoft.JET.OLEDB.4.0;data source= D:\Patients2000.mdb"
Dim sqlStr As String = "SELECT * FROM Patients"
Dim conn As New System.Data.OleDb.OleDbConnection(conStr)
Dim ds As DataSet = New DataSet()
Dim da As New System.Data.OleDb.OleDbDataAdapter(sqlStr, conn)
da.Fill(ds)

Dim mc As New FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType
mc.DataSourceList = ds
mc.DataMemberList = "Patients"

FpSpread1.ActiveSheet.Cells(0, 0).CellType = mc

Requirements

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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.