Display dataset results in a random order

[jt_advance]

I'm connecting to an MS Access database to retireve my data and wan to display
my results in a random order. What i have is a table containing various
banners which are linked to various pages in my website (the URL is also stored
in the dataset) and would like these to appear in a random order.

My webpages are ASP.Net

[Paul Whitham TMM]

If you were using a msSQL database then it is very simple as there is a SQL
function to do this. Unfortunately it is not available in Access. Have a
look at this article [url]http://aspnet.4guysfromrolla.com/articles/051003-1.aspx[/url]
as it explains how to achieve the same result against the datatables that
are contained within the dataset.


--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"jt_advance" <webforumsuser@macromedia.com> wrote in message
news:d7245p$qbo$1@forums.macromedia.com...

> I'm connecting to an MS Access database to retireve my data and wan to

display

> my results in a random order. What i have is a table containing various
> banners which are linked to various pages in my website (the URL is also

stored

> in the dataset) and would like these to appear in a random order.
>
> My webpages are ASP.Net
>