%
If Session("logged") <> "1" Then
Response.Redirect("login.asp")
End If
%>
Products list
<%
Dim DateID, ConnectionString, cnUpd, recProducts
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../db/db1.mdb") & ";"
%>
List of Products
| Product Name | |
<%
Set cnUpd = Server.CreateObject("ADODB.Connection")
cnUpd.Open ConnectionString
Set recProducts = Server.CreateObject("ADODB.Recordset")
recProducts.Open "Select * From Products ORDER By id", cnUpd, adForwardOnly
While Not recProducts.EOF
%>
| <%=recProducts("ProductsName")%> | ">Delete |
<%
recProducts.MoveNext
Wend
recProducts.Close
cnUpd.Close
Set cnUpd = Nothing
Set recProducts = Nothing
%>