Example1 ASP
Paste this code into a file and save it as example1.asp in your sample folder.
<html>
<body>
<%Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "NorthwindDSN"
sql = "SELECT LastName, FirstName FROM Employees"
Set rst = Conn.Execute(sql) %>
<%Do While Not rst.EOF%>
<%=rst("LastName")%>
<%=rst("FirstName")%>
<%=rst.MoveNext
Loop
Set Conn = Nothing
Set rst = Nothing %>
</body>
</html>
Click Next for example2.asp
No comments:
Post a Comment
Comments subject to moderation before publishing.