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

Members online

No members online now.

Forum statistics

Threads
473,787
Messages
2,569,630
Members
45,334
Latest member
66Zeinab9

Latest Threads

Top