DataRow.CancelEdit Method

Definition

Namespace:
System.Data
Assembly:
System.Data.Common.dll
Assembly:
System.Data.dll
Assembly:
netstandard.dll

Cancels the current edit on the row.

public:
 void CancelEdit();
public void CancelEdit ();
member this.CancelEdit : unit -> unit
Public Sub CancelEdit ()

Exceptions

InRowChangingEventException

The method was called inside the RowChanging event.

Examples

The following example edits the value of one column in the last row of a DataGrid control. The example uses the BeginEdit, EndEdit, methods to edit the column's value and commit the change to the row.

private void AcceptOrReject(DataRow row)
{
    // Use a function to validate the row's values.
    // If the function returns true, end the edit;
    // otherwise cancel it.
    if(ValidateRow(row))
        row.EndEdit();
    else
        row.CancelEdit();
}

private bool ValidateRow(DataRow thisRow)
{
    bool isValid = true;
    // Insert code to validate the row values.
    // Set the isValid variable.
    return isValid;
}

 Private Sub AcceptOrReject(ByVal row As DataRow)
    ' Use a function to validate the row's values.
    ' If the function returns true, end the edit; 
    ' otherwise cancel it.
    If ValidateRow(row) Then
       row.EndEdit()
    Else
       row.CancelEdit()
    End If
End Sub
 
Private Function ValidateRow(ByVal row As DataRow) As Boolean
    Dim isValid As Boolean
    ' Insert code to validate the row values. 
    ' Set the isValid variable.
    ValidateRow = isValid
End Function

Remarks

See the BeginEdit method for more information.

Applies to

See also