Step 3: Show me my data.

Now that all of our data is stored in our RecordSet (called RecordSet1) we must display it. Initially I'm just going shove it all onto the screen, quite messy but I'll clean it up later. To view data then you need these statements: NOTE: We are only going to show 1 column otherwise it gets a bit messy. When we move onto the next few steps I will be doing all of the columns.

While Not RecordSet1.EOF %><%=(Recordset1.Fields.Item("Address").Value)%><% Response.Write("<br>") RecordSet1.MoveNext Wend

This is a simple While Statement. The Not is the same as <> and RecordSet1.EOF is a Boolean property that tells us if it is at the bottom record or not. The next line closes off the ASP tag only to open it with a Response.Write tag and to make it more clear I did this. Recordset1.Fields.Item("") is just that, a field in the current row, called Address in this case, then we get the value of that cell.
This will return the following screenshot:

Wrap up

I'll wrap up this section here before we start doing the tables.