Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / MultiColumnComboBoxCellType Class / DataMember Property
Example


In This Topic
    DataMember Property (MultiColumnComboBoxCellType)
    In This Topic
    Gets or sets the name of the data member that populates the list in the list portion of the combo box.
    Syntax
    'Declaration
     
    Public Property DataMember As String
    'Usage
     
    Dim instance As MultiColumnComboBoxCellType
    Dim value As String
     
    instance.DataMember = value
     
    value = instance.DataMember
    public string DataMember {get; set;}
    Example
    This example uses the DataMember 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.DataMember = "LastName";
    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
    mccbct.DataMember = "LastName"
    FpSpread1.ActiveSheetView.Cells(0, 0).CellType = mccbct
    See Also