Here is a screenshot of our database. It’s a table called "users" in a database called "workshop.mdb". We have already created our connections called "workshop" and we are ready to go! This database has 14 example records so that we can work with.

Open a new file in UltraDev and name it "displayrecords.asp". Go to Windows > Data Bindings. It will bring up a window like the one to the left. Press the + (plus) sign and a drop down menu will appear. Select Recordset (Query) from the drop down menu list.

A new window will appear where you can select the connection you want to use and table you want to pull it from. Think of your connection as your database, and the tables are categories underneath it that you want to select information from

Here we are going to pull information from the database.

• At the name field I call items rsGetRecords. (rs) stands for recordset commonly in ASP terms. It’s easier to see your recordsets if you start with rs.


• Select your connection from the drop down.


• Select the table you want to pull the information from.


• In columns we’ll just leave it set to "All" so that we make sure we have access to all the fields.


• Leave filter set to none for now, because we want to pull all the records onto the page.


• And set sort to first > ascending. First is one of our fields in the database. And we want it sorting names for A to Z.

Just press OK and now you’ve connected with ASP code to the database. You won’t see anything on the page yet. That’s what we will do next.