Low cost ecommerce web development India flash website design
DATA MANIPULATION USING ASP
Here we shall look at a practical example of using ASP & ADO to create a
database-driven website. We'll tackle it piecemeal, looking at the simpler
queries first and then moving on to more complex ones.
Displaying Data from a Table
Let us have a running database example for this section. Consider a database
for a class of students.
The database schema is as follows:
Table: Student
ID Student ID Numbers; also the primary key of the table.
FirstName First name of the Student.
LastName Last name of the Student.
DateofBirth Birthdate of the Student.
Email Email address of the student.
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> <p><a href="http://www.vishwatech.com" title="Low cost ecommerce web development India
flash website design">Low cost ecommerce web development India
flash website design</a>
<%
Dim DB
35
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>
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73