FormView.DeleteItem Method ()

 

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

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

Public Overridable Sub DeleteItem

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.

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="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") %>&nbsp;<%# 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>

.NET Framework
Available since 2.0
Return to top
Show: