Spread for ASP.NET 8.0 Product Documentation
ButtonCellType Constructor(String,ButtonType,String)
Example 


String of command to perform when the user clicks the button
Button type
Image URL if the button type is ButtonType.ImageButton; otherwise, the button text
Creates a new button cell with the specified command and button type.
Syntax
'Declaration
 
Public Function New( _
   ByVal cmd As String, _
   ByVal type As ButtonType, _
   ByVal urlOrText As String _
)
'Usage
 
Dim cmd As String
Dim type As ButtonType
Dim urlOrText As String
 
Dim instance As New ButtonCellType(cmd, type, urlOrText)
public ButtonCellType( 
   string cmd,
   ButtonType type,
   string urlOrText
)

Parameters

cmd
String of command to perform when the user clicks the button
type
Button type
urlOrText
Image URL if the button type is ButtonType.ImageButton; otherwise, the button text
Example
This example shows the use of this constructor by creating a spreadsheet, setting the first two columns of cells to be button cells and constructing the buttons with a CommandNames of "MyRed" and "MyBlue". (In the ButtonCommand event the CommandNames are queried and the background color of the spreadsheet is changed depending on the CommandName.)
FpSpread1.Sheets[0].ColumnCount=7;
FpSpread1.Sheets[0].RowCount=50;
FarPoint.Web.Spread.ButtonCellType btn=new FarPoint.Web.Spread.ButtonCellType("MyRed",ButtonType.PushButton,"Red");
FarPoint.Web.Spread.ButtonCellType btn1=new FarPoint.Web.Spread.ButtonCellType("MyBlue",ButtonType.PushButton,"Blue");
FarPoint.Web.Spread.StyleInfo style=new FarPoint.Web.Spread.StyleInfo();
FarPoint.Web.Spread.StyleInfo style1=new FarPoint.Web.Spread.StyleInfo();
style.CellType=btn;
style1.CellType=btn1;
FpSpread1.Sheets[0].SetStyleInfo(-1,0,style);
FpSpread1.Sheets[0].SetStyleInfo(-1,1,style1);
private void FpSpread1_ButtonCommand(object sender,FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
if(e.CommandName=="MyRed")
{
FpSpread1.Sheets[0].BackColor=Color.Red;
}
elseif(e.CommandName=="MyBlue")
{
FpSpread1.Sheets[0].BackColor=Color.Blue;
}
}
Dim btn As New FarPoint.Web.Spread.ButtonCellType("MyRed",ButtonType.PushButton,"Red")
Dim btn1 As New FarPoint.Web.Spread.ButtonCellType("MyBlue",ButtonType.PushButton,"Blue")
Dim style As New FarPoint.Web.Spread.StyleInfo()
Dim style1 As New FarPoint.Web.Spread.StyleInfo()
FpSpread1.Sheets(0).ColumnCount=7
FpSpread1.Sheets(0).RowCount=50
style.CellType=btn
style1.CellType=btn1
FpSpread1.Sheets(0).SetStyleInfo(-1,0,style)
FpSpread1.Sheets(0).SetStyleInfo(-1,1,style1)
Private Sub FpSpread1_ButtonCommand(ByVal sender As Object,ByVal e As FarPoint.Web.Spread.SpreadCommandEventArgs)Handles FpSpread1.ButtonCommand
If e.CommandName="MyRed" Then
FpSpread1.Sheets(0).BackColor=Color.Red
ElseIf e.CommandName="MyBlue" Then
FpSpread1.Sheets(0).BackColor=Color.Blue
End If
End Sub
Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

ButtonCellType Class
ButtonCellType Members
Overload List
CommandName Property
ButtonType Property
ImageUrl Property
Text Property

 

 


Copyright © GrapeCity, inc. All rights reserved.