Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / InsertCommand Event
Example


In This Topic
    InsertCommand Event
    In This Topic
    Occurs when the user clicks on the Insert button on the component and inserts a new row in the active sheet.
    Syntax
    'Declaration
 

    Public Event InsertCommand As SpreadCommandEventHandler
    'Usage
 

    Dim instance As FpSpread
Dim handler As SpreadCommandEventHandler
 
AddHandler instance.InsertCommand, handler
    public event SpreadCommandEventHandler InsertCommand
    Event Data

    The event handler receives an argument of type SpreadCommandEventArgs containing data related to this event. The following SpreadCommandEventArgs properties provide information specific to this event.

    PropertyDescription
    CommandArgumentGets the argument for the command. (Inherited from System.Web.UI.WebControls.CommandEventArgs)
    CommandNameGets the name of the command. (Inherited from System.Web.UI.WebControls.CommandEventArgs)
    EditValuesGets the postback data in an array list of values.  
    HandledGets or sets whether the event has been handled.  
    SheetViewGets the sheet being updated.  
    SortFrozenRowsGets or sets whether the frozen rows should be sorted when the sorting command occurs.  
    Remarks

    To display the Insert button, set the SheetView AllowInsert property to true.

    You can write code in this event to perform actions when a row is inserted.

    The SpreadCommandEventHandler receives an argument of type SpreadCommandEventArgs containing data related to this event.

    Example
    This example illustrates the use of the event. 
    
	
    
	
    
		
    
	
    
	

    

    
            
            
            
            
            
    See Also
    Reference
    FpSpread Class

    FpSpread Members

    ButtonType Property