DataPager and ListView with Randomized Rows?

M

MU

Hello

Is there a way for me to have a DataPager linked to a ListView and
have the rows returned in a randomized order? When I use:
ORDER BY NEWID()
in my query, the first page comes back randomized but when you click
to the next page, the rows are randomized again. Is there a way to
use just one dataset instead of the rows being randomized each time
the user clicks next?

Thanks!
MU
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Staff online

Members online

Forum statistics

Threads
473,991
Messages
2,570,217
Members
46,805
Latest member
ClydeHeld1

Latest Threads

Top