Delete Select ASP Code
<%strSQL = "SELECT ProductID, ProductName "
strSQL = strSQL & "FROM Products "
strSQL = strSQL & "WHERE Discontinued=True"
Set rst= Server.CreateObject("ADODB.Recordset")
Set cnn= Server.CreateObject("ADODB.Connection")
cnn.open "NorthWindDSN"
rst.open strSQL, cnn
%>
<html>
<head>
<title>Delete product</title>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Click the product that you want to delete.</p>
<hr>
<%
Do While Not rst.EOF
%>
<a href="delete.asp?ProductID=<%=rst("ProductID")%>"> <%=rst("ProductName")%></a>
<%
rst.Movenext
Loop
%>
</body>
</html>
Go Top
MS-Access and Internet.
- Installing the Personal Web Server (PWS)
- or Internet Information Services (IIS)
- Create the Example ASP Files
- Create a DSN Connection
- Connect to the Database
- Modify Access Data Online
- Inserting Data
- Modifying Data
- Deleting Data
- Data Insert Form
Enable GingerCannot connect to Ginger Check your internet connection
or reload the browserDisable in this text fieldEditEdit in GingerEdit in Ginger
No comments:
Post a Comment
Comments subject to moderation before publishing.