Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / MultiColumnComboBoxCellType Class / DataColumnName Property
Example


In This Topic
    DataColumnName Property (MultiColumnComboBoxCellType)
    In This Topic
    Gets or sets which list column (by name) serves as the data portion of the combo box.
    Syntax
    'Declaration
     
    Public Property DataColumnName As String
    'Usage
     
    Dim instance As MultiColumnComboBoxCellType
    Dim value As String
     
    instance.DataColumnName = value
     
    value = instance.DataColumnName
    public string DataColumnName {get; set;}

    Property Value

    String containing the list column name
    Example
    This example sets up the multi column combobox.
    string conStr = "Provider=Microsoft.JET.OLEDB.4.0;data source=c:\\nwind.mdb";
    string sqlStr = "SELECT * FROM Employees";
    System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(conStr);
    Data.DataSet ds = new Data.DataSet();
    System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sqlStr, conn);
    da.Fill(ds);
    FarPoint.Web.Spread.MultiColumnComboBoxCellType mcb = new FarPoint.Web.Spread.MultiColumnComboBoxCellType();
    mcb.ColumnEdit = 2;
    mcb.ColumnEditName = "Last Name";
    mcb.ColumnWidths = new int[] {
            80,
            80,
            80,
            80,
            80,
            80,
            80,
            80,
            80,
            80,
            80,
            80,
            80,
            80,
            80,
            80};
    mcb.DataColumn = 1;
    mcb.DataColumnName = "First Name";
    mcb.ListAlignment = FarPoint.Web.Spread.Editor.ListAlignment.Right;
    mcb.ListHeight = 390;
    mcb.ListOffset = -30;
    mcb.ListWidth = 520;
    mcb.ShowButton = true;
    mcb.DataSource = ds;
    FpSpread1.Sheets[0].Cells[0, 0].CellType = mcb;
    Dim conStr As String = "Provider=Microsoft.JET.OLEDB.4.0;data source=c:\\nwind.mdb"
    Dim sqlStr As String = "SELECT * FROM Employees"
    Dim conn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(conStr)
    Dim ds As Data.DataSet = New Data.DataSet()
    Dim da As System.Data.OleDb.OleDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter(sqlStr, conn)
    da.Fill(ds)
    
    Dim mcb As New FarPoint.Web.Spread.MultiColumnComboBoxCellType
    mcb.ColumnEdit = 2
    mcb.ColumnEditName = "Last Name"
    mcb.ColumnWidths = New Integer() {80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80}
    mcb.DataColumn = 1
    mcb.DataColumnName = "First Name"
    mcb.ListAlignment = FarPoint.Web.Spread.Editor.ListAlignment.Right
    mcb.ListHeight = 390
    mcb.ListOffset = -30
    mcb.ListWidth = 520
    mcb.ShowButton = True
    mcb.DataSource = ds
    FpSpread1.Sheets(0).Cells(0, 0).CellType = mcb
    See Also