Pure ASP Upload - List of records with images

Making a list of records with images

In this tutorial we will explain how to make a nice list of records with images. We will use the same biography example as in the previous tutorials. Also you will use the created insert and update page from the Upload and insert record form and Upload and update record form tutorials.

How to do it

To make file upload and insert a record, you need to:

1. Make the new list page

   You can start with a new blank page.

2. Add a Recordset

   You will need a recordset to get a list of all records.

   

3. Insert File Name

   Put your cursor on the page. Open the Bindings Panel. Select Name and click insert.

   You will see {rs.Test.name} on your page.

4. Add the image

   Next we will insert the image. Currently you have only the file name displayed as {rsBio.Picture}

   Then click on the Insert Image icon or choose it from the Insert menu. Instead of selecting an existing image from the File system, you should choose Data Sources !

   

   Then select the Picture field from the rsBio recordset. Because we uploaded all pictures to the Upload folder and store only the filename in the database, you need to put Upload/ before the database field.

5. Add a Repeat Region

   Now that we have inserted the image, we need to make a repeat region from this record. So you can see a list of all records.

   First select the whole first row, then choose Repeat Region from the Server Behaviors palette.

   

   Now we have a full working list of all existing biographies in the database. But of course we want to add more actions.

6. Save and done

   Save your page and upload it to your server, and you are done! Go to your website and test it - you should be able to list records!