Example2 ASP
Paste this code into a file and save it as example2.asp in your sample folder.
<html>
<body>
<%Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "NorthwindDSN"
sql = "SELECT LastName, FirstName FROM Employees WHERE LastName = 'Reid' "
Set rst = Conn.Execute(sql)
If rst.EOF Then
Response.Write "No employee records available"
Conn.Close
Set Conn = Nothing
Response.End
End if %>
<%Do While Not rst.EOF%>
<%=rst("LastName")%>
<%=rst("FirstName")%>
<%=rst.MoveNext
Loop
Set Conn = Nothing
Set rst = Nothing %>
</body>
</html> Click Next for example3.asp
- 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
No comments:
Post a Comment
Comments subject to moderation before publishing.