An Introduction to ASP Delete database records tutorial

ASP Tutorial Removing database Tutorial records Getting Started tutorial
<script>
 function Check ()
 {
  if (Confirm (' Confirm delete ', ')
  {
  //Operation
 }
 }
</script>
<table width= "312" border= "0" >
  <TR>
    <td width= ">A</TD>
    <td width=" >b</td>
  </tr>
  <TR>
    <td>www.3lian.net </ Td>
    <td><a href= "? id=5" onclick= "check ();" > Delete </a></td>
  </tr>
</table>

//asp Delete database records Getting Started tutorial
  Sitedb = "Database/mdb.mdb"
  Set Conn = Server.CreateObject ("adodb.connection")
  connstr= "provider=" Microsoft.jet.oledb.4.0;data source= "& Server.MapPath (sitedb)
  conn.open connstr
  Set rs= Server.CreateObject ("Adodb.recordset")
 
  DIM SQL
  sql = "Delete from test wheRe id= "&request.query (" id ")
  if Rs.execute (SQL) then
   Response.Write (" delete successful ")
  E LSE
   Response.Write ("Delete failed")
  End If