The following tutorial follows on from Reading records from an Access Database, Inserting Records and Updating records in an Access Database. We’ve been working with a Microsoft Access Database called “Customers.mdb” located at C:\Inetpub\wwwroot\code\Customers.mdb.
Again we’ll not go into importing the System.Data.Oledb Namespace, creating the connection object and the command object and passing parameters into these objects as these have been covered extensively in the previous three parts.
The source code below uses the ExecuteNonQuery method of our Command object to execute an SQL delete statement.
We’ve added a label ‘label1’ control to our page and set it’s text property to ‘Record Deleted’ once the code has been run.
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data.Oledb" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Dim Connection As OledbConnection
Connection = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;" & _
"Data Source=C:\Inetpub\wwwroot\code\Customers.mdb")
Connection.Open()
Dim Command As OleDbCommand
Command=New OleDbCommand("DELETE * FROM tblCustomers WHERE LastName= 'Wall'", Connection)
Command.ExecuteNonQuery()
Connection.Close()
Label1.Text="Record Deleted"
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Delete Record(s) in MS Access Database</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:label ID=label1 runat="server" />
</div>
</form>
</body>
</html>
Searching Records with ASP.NET >> Part 1 |
Plug and play ASP membership script that integrates with PayPal to let you charge recurring membership fees.
Get your best asp web hosting provider now and save 25%
