Low cost ecommerce web development India flash website design
Retrieving Data
You’ll need to use the SQL SELECT statement for reading in data from a
table. (More about SQL can be found in a later chapter, an SQL Reference).
Let’s say, we want to display a complete list of all the students in the
class.
Here is a complete page that lists out all the student records in a Table.
<HTML>
<HEAD>
<TITLE>Student Records</TITLE>
</HEAD>
<BODY>
<%
Dim DB
Set DB = Server.CreateObject (“ADODB.Connection”)
DB.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" +
“C:\Databases\Students.mdb”)
Dim RS
Set RS = Server.CreateObject (“ADODB.Recordset”)
RS.Open “SELECT * FROM Students”, DB
If RS.EOF And RS.BOF Then
Response.Write “There are 0 records.”
Else
RS.MoveFirst
While Not RS.EOF
Response.Write RS.Fields (“FirstName”)
Response.Write RS.Fields (“LastName”)
Response.Write “<HR>”
RS.MoveNext
Wend
End If
%>
</BODY>
</HTML>
Freelance web designer ASP PHP ecommerce web development India