Edit

Share via


FormView.DeleteItem Method

Definition

Deletes the current record in the FormView control from the data source.

public:
 virtual void DeleteItem();
public virtual void DeleteItem ();
abstract member DeleteItem : unit -> unit
override this.DeleteItem : unit -> unit
Public Overridable Sub DeleteItem ()

Examples

The following example demonstrates how to use the DeleteItem method to programmatically delete the current record in a FormView control from the data source.


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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
  
  void DeleteButton_Click(Object sender, EventArgs e)
  {

    // Use the DeleteItem method to programmatically delete
    // the current record in the FormView control. 
    EmployeeFormView.DeleteItem();

  }

</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
  <head runat="server">
    <title>FormView DeleteItem Example</title>
</head>
<body>
    <form id="form1" runat="server">
        
      <h3>FormView DeleteItem Example</h3>
                       
      <asp:formview id="EmployeeFormView"
        datasourceid="EmployeeSource"
        allowpaging="true"
        datakeynames="EmployeeID" 
        runat="server">
        
        <itemtemplate>
        
          <table>
            <tr>
              <td>
                <asp:image id="EmployeeImage"
                  imageurl='<%# Eval("PhotoPath") %>'
                  alternatetext='<%# Eval("LastName") %>' 
                  runat="server"/>
              </td>
              <td>
                <h3><%# Eval("FirstName") %> <%# Eval("LastName") %></h3>      
                <%# Eval("Title") %>        
              </td>
            </tr>
          </table>
        
        </itemtemplate>
          
      </asp:formview>
      
      <hr/>
      
      <asp:Button id="DeleteButton"
        text="Delete Record"
        onclick="DeleteButton_Click" 
        runat="server"/>
          
      <!-- 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%>" 
        runat="server"/>
            
    </form>
  </body>
</html>

<%@ Page language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
  
  Sub DeleteButton_Click(ByVal sender As Object, ByVal e As EventArgs)

    ' Use the DeleteItem method to programmatically delete
    ' the current record in the FormView control. 
    EmployeeFormView.DeleteItem()

  End Sub

</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
  <head runat="server">
    <title>FormView DeleteItem Example</title>
</head>
<body>
    <form id="form1" runat="server">
        
      <h3>FormView DeleteItem Example</h3>
                       
      <asp:formview id="EmployeeFormView"
        datasourceid="EmployeeSource"
        allowpaging="true"
        datakeynames="EmployeeID" 
        runat="server">
        
        <itemtemplate>
        
          <table>
            <tr>
              <td>
                <asp:image id="EmployeeImage"
                  imageurl='<%# Eval("PhotoPath") %>'
                  alternatetext='<%# Eval("LastName") %>' 
                  runat="server"/>
              </td>
              <td>
                <h3><%# Eval("FirstName") %> <%# Eval("LastName") %></h3>      
                <%# Eval("Title") %>        
              </td>
            </tr>
          </table>
        
        </itemtemplate>
          
      </asp:formview>
      
      <hr/>
      
      <asp:Button id="DeleteButton"
        text="Delete Record"
        onclick="DeleteButton_Click" 
        runat="server"/>
          
      <!-- 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%>" 
        runat="server"/>
            
    </form>
  </body>
</html>

Remarks

Use the DeleteItem method to programmatically delete the current record in the FormView control from the data source. This method is commonly used when you need to delete the current record from outside of the FormView control, such as from a different control on the page. Calling this method also raises the ItemDeleted and ItemDeleting events.

Applies to

See also