This documentation is archived and is not being maintained.

FormViewDeletedEventArgs.AffectedRows Property

Gets the number of rows affected by the delete operation.

Namespace: System.Web.UI.WebControls
Assembly: System.Web (in system.web.dll)

public int AffectedRows { get; }
/** @property */
public int get_AffectedRows ()

public function get AffectedRows () : int

Not applicable.

Property Value

The number of rows affected by the delete operation.

Use the AffectedRows property to determine the number of records affected by the delete operation. This property is commonly used to verify that the correct number of records was deleted in the following situations:

  • Verify that only a single record was deleted. Sometimes an improperly written delete statement can delete multiple records.

  • Verify that a record was deleted when an error occurs during the delete operation that does not raise an exception.

  • Verify that a record was deleted when a data source control that supports conflict detection (optimistic concurrency), such as the SqlDataSource and ObjectDataSource controls, has its ConflictDetection property set to the ConflictOptions.CompareAllValues enumeration value. Under this setting, a record that has been modified by another user concurrently might not be deleted.

The following example demonstrates how to use the AffectedRows property to verify that a record was deleted during the delete operation.

<%@ Page language="C#" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
<script runat="server">

  void EmployeeFormView_ItemDeleted(Object sender, FormViewDeletedEventArgs e)
    // Use the Exception property to determine whether an exception
    // occurred during the delete operation.
    if (e.Exception == null)
      // Use the AffectedRows property to determine whether the
      // record was deleted. Sometimes an error might occur that 
      // does not raise an exception, but prevents the delete
      // operation from completing.
      if (e.AffectedRows == 1)
        MessageLabel.Text = "Record deleted successfully.";
        MessageLabel.Text = "An error occurred during the delete operation.";
      // Insert the code to handle the exception.
      MessageLabel.Text = e.Exception.Message;
      // Use the ExceptionHandled property to indicate that the 
      // exception has already been handled.
      e.ExceptionHandled = true;


<html xmlns="" >
  <head runat="server">
    <title>FormViewDeletedEventArgs Example</title>
    <form id="form1" runat="server">
      <h3>FormViewDeletedEventArgs Example</h3>
      <asp:formview id="EmployeeFormView"
                <asp:image id="EmployeeImage"
                  imageurl='<%# Eval("PhotoPath") %>'
                  alternatetext='<%# Eval("LastName") %>' 
                <h3><%# Eval("FirstName") %>&nbsp;<%# Eval("LastName") %></h3>      
                <%# Eval("Title") %>        
              <td colspan="2">
                <asp:button id="DeleteButton"
                  text="Delete Record"
                  runat="server" />
      <asp:label id="MessageLabel"
      <!-- This example uses Microsoft SQL Server and connects  -->
      <!-- to the Northwind sample database. Use an ASP.NET     -->
      <!-- expression to retrieve the connection string value   -->
      <!-- from the Web.config file.                            -->
      <asp:sqldatasource id="EmployeeSource"
        selectcommand="Select [EmployeeID], [LastName], [FirstName], [Title], [PhotoPath] From [Employees]"
        deletecommand="Delete [Employees] Where [EmployeeID]=@EmployeeID"
        connectionstring="<%$ ConnectionStrings:NorthWindConnectionString%>" 

Windows 98, Windows Server 2000 SP4, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0