Returning a recordset from a database

Home > Asp > Tutorials > Returning a recordset from a database - ASP Tutorial

Tell a friend

Link to us

Total Members

Members: 84606

Home

1 . Introduction to ASP

2 . Setting up your ASP environment

3 . First ASP Page

4 . Active Server Objects

5 . Global.asa

6 . Application Object

7 . Session Object

8 . Request Object

9 . Response Object

10 . Server Object

11 . ASP Server Side Includes

12 . Connecting to a database

13 . Returning a recordset from a database

14 . Formatting a recordset as a HTML table

15 . Populating a dropdown list from a database

16 . Creating an automated email

17 . Sending attachments via an automated email

18 . What is the FileSystemObject?

19 . Total number of users are accessing the ASP application?

20 . Logging users

Asp Group Home

Asp Discussion (86)

Asp Members (23063)

Asp Resources

Asp Source Code (238)

- Asp Unanswered Questions

GROUPS

.NET

Java

Other

TUTORIALS

.NET

.NET Tutorial

ASP Tutorial

ASP.NET Database Tutorial

ASP.NET Development Tips

ASP.Net Security,Internationalisation And Deployment

ASP.NET Server Controls Tips

Web Development

Software Development

Java

Java Web Component Tutorial

JSP And J2EE Design Tutorial

RESOURCES

SUBMISSIONS

COMMUNITY

SITE

Asp Tutorial

Returning a recordset from a database

<< Prev: Connecting to a database

Next: Formatting a recordset as a HTML table >>

To return a recordset to the browser you would use the Recordset object.

<html>

<head>

<title>

</title>

</head>

<body>

<%

Set cn = Server.CreateObject("ADODB".Connection")

cn.Open "Company"

Set rs =cn.Execute "SELECT FirstName,LastName FROM Employees"

rs.MoveFirst

Do While Not rs.EOF

Response.Write " First Name : " & rs("FirstName") & " Last Name: " & rs("LastName") & "<BR>"

rs.Movenext

Loop

%>

</body>

</html>