How to solve this? Random record in dataset or AdRotator

[Miguel Dias Moura]

Hello,

I need to display a random image in an ASP.Net/VB web page.

I created a dataset which connects to an access database.
So I got 2 fields:
- Link where the image is placed.
- Link to go when the image is clicked.

Well, I placed an image in the page using this line:
<img src='images/<%# dsImageBank.FieldValue("image", Container) %>' />

This shows the image of the last loaded record of the dataset.
How to make this random?

I looked at the AdRotator component but it gets the images from XML and
I need to get the images from the database.

Can someone help me out?
I am short on time here.

Thanks,
Miguel

 

[Ken Cox [Microsoft MVP]]

Hi Miguel,

The easiest way would be to determine how many records are in your database
and then get a random number within that range. Use the random number as
part of a SQL query to retrieve the image.

http://msdn.microsoft.com/library/d...us/cpref/html/frlrfSystemRandomClassTopic.asp

Ken
Microsoft MVP [ASP.NET]
Toronto