asp database delete record for beginners. Learn asp delete stateemnt basics

  :: Home

PC Topics

  :: Build A PC

  :: Windows XP

  :: PC Help

Tutorials

  :: HTML

  :: JavaScript

  :: ASP

  :: PHP

  :: VBScript

  :: SQL

Miscellaneous

  :: Code/Scripts

  :: Forum

  :: Links

  :: Contact us

  :: Tell A Friend

  :: In Somali

  ::

Web Articles

Top Web Hosting
Reviews

Processing
Online Card Payment Guide

Domain name
registration & buying guide

Getting
a website online guide

Search Engine
submission & optimization tips

Quality business correspondence.

ASP - Delete a record

We are going to use two files in order to delete a record. First file (toDelete.asp) is to view all the records and the second file (deleteComment.asp) is to delete selected record.

Code to list records from *tblFeeds*
Select name to delete. <% Dim Conn, Rs, sql Set Conn = Server.CreateObject("ADODB.Connection") Set Rs = Server.CreateObject("ADODB.Recordset") Conn.Open "DRIVER={Microsoft Access Driver (.mdb)}; DBQ=" & Server.MapPath("FeedBack.mdb") sql= "SELECT FROM tblFeeds;" Rs.Open sql, Conn Response.Write "<FORM name='Delete' method='post' action='DeleteComment.asp'>" Response.Write "<table border=1 cellspacing=0>" Response.Write "<tr>"&"<td colspan='3' align='center'>"&"Select a comment to delete and click delete"&"</td>"&"</tr>" Response.Write "<tr>"&"<th align='center' colspan='2'>"&"Name"&"</th>"&"<th align='center'>"&"Comment"&"</th>"&"</tr>" Do While not Rs.EOF Response.Write ("<tr>") Response.Write ("<td>"&"<input type='radio' name='ID' value="&Rs("user_id")&">"&"</td>") Response.Write ("<td>"&Rs("name")&"</td>") Response.Write ("<td>"&Rs("comments")&"</td>") Response.Write ("</tr>") Rs.MoveNext Loop Response.Write("<tr>"&"<td colspan='3' align='center'>"&"<input type ='submit' name='submit' value='Delete' onClick='return validate();'>"&"</td>"&"</tr>") Response.Write "</table>" Response.Write "</form>" Rs.Close Set Rs = Nothing Set Conn = Nothing %>

The purpose of this file to view records and select one. Selected record is deleted through deleteComment.asp file.

deleteComment.asp file
<% Dim ID ID = Request.Form("ID") if ID="" then Response.Write "You did not select a name to delete!" Else Dim Conn Dim Rs Dim sql Set Conn = Server.CreateObject("ADODB.Connection") Set Rs = Server.CreateObject("ADODB.Recordset") Conn.Open "DRIVER={Microsoft Access Driver (.mdb)}; DBQ=" & Server.MapPath("FeedBack.mdb") sql= "Delete FROM tblFeeds WHERE user_ID='" & ID Rs.Open sql, Conn Conn.Close Set Conn = Nothing Response.Write "Successfully Deleted" End If %>

Update Data

Virtual Includes

Your Ad Here

Listed @ ConsumerVote.com - The Consumer Rated Web Directory

PC Articles

Computer Safety
prevent viruses & Spyware