Spread for ASP.NET 9.0 Product Documentation
ShowButton Property (MultiColumnComboBoxCellType)
Example 


Gets or sets whether to display the button.
Syntax
'Declaration
 
Public Property ShowButton As Boolean
'Usage
 
Dim instance As MultiColumnComboBoxCellType
Dim value As Boolean
 
instance.ShowButton = value
 
value = instance.ShowButton
public bool ShowButton {get; set;}

Property Value

Boolean: true to display the button; false otherwise
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
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

MultiColumnComboBoxCellType Class
MultiColumnComboBoxCellType Members

 

 


Copyright © GrapeCity, inc. All rights reserved.