Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Event InsertCommand As SpreadCommandEventHandler | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As FpSpread Dim handler As SpreadCommandEventHandler AddHandler instance.InsertCommand, handler | |
| C# | |
|---|---|
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.
| Property | Description |
|---|---|
| CommandArgument (Inherited from System.Web.UI.WebControls.CommandEventArgs) | Gets the argument for the command. |
| CommandName (Inherited from System.Web.UI.WebControls.CommandEventArgs) | Gets the name of the command. |
| EditValues | Gets the postback data in an array list of values. |
| Handled | Gets or sets whether the event has been handled. |
| SheetView | Gets the sheet being updated. |
| SortFrozenRows | Gets 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.
| C# | Copy Code |
|---|---|
private void FpSpread1InsertCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e) { TextBox1.Text = "You inserted a row at index " + e.CommandArgument; } | |
| Visual Basic | Copy Code |
|---|---|
Private Sub FpSpread1InsertCommand(ByVal sender As Object, ByVal e As FarPoint.Web.Spread.SpreadCommandEventArgs) Handles FpSpread1.InsertCommand TextBox1.Text = "You inserted a row at index " & e.CommandArgument 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