Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / UpdateCommand Event
Example


In This Topic
    UpdateCommand Event
    In This Topic
    Occurs when the user clicks the Update button on the component.
    Syntax
    'Declaration
     
    Public Event UpdateCommand As SpreadCommandEventHandler
    'Usage
     
    Dim instance As FpSpread
    Dim handler As SpreadCommandEventHandler
     
    AddHandler instance.UpdateCommand, handler
    public event SpreadCommandEventHandler UpdateCommand
    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
    Gets the argument for the command. (Inherited from System.Web.UI.WebControls.CommandEventArgs)
    Gets the name of the command. (Inherited from System.Web.UI.WebControls.CommandEventArgs)
    Gets the postback data in an array list of values.  
    Gets or sets whether the event has been handled.  
    Gets the sheet being updated.  
    Gets or sets whether the frozen rows should be sorted when the sorting command occurs.  
    Remarks

    You can write code in this event to perform actions after the data is updated.

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

    Example
    This example illustrates the use of the event.
    private void FpSpread1UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e) 
    {
        int i = (int)e.CommandArgument;
        if (e.EditValues.[7] == true)
        {
            FpSpread1.Sheets[0].RemoveRows(i, 1);
        }
    }
    
    Private Sub FpSpread1UpdateCommand(ByVal sender As System.Object, ByVal e As FarPoint.Web.Spread.SpreadCommandEventArgs) Handles
    FpSpread1.UpdateCommand
        Dim i As Integer = e.CommandArgument
        If e.EditValues.Item(7) = True Then
            FpSpread1.Sheets(0).RemoveRows(i, 1)
        End If
    End Sub
    See Also