Select Random rows

[mentalhard]

SELECT TOP 2 ID, Rnd([ID]) AS Expr1, fname, lname 
FROM users
ORDER BY Rnd([ID]);

the SELECT Statement works perfect inside MS Access environment. I made a query for testing purpose and it works. then i tried the same statement from vb.NET application (ASP.NET) and it returns the same two records all the time.

What's wrong with this statement so it doesn't work in .NET environment. And have i other options to get two random rows from the table users?

Thanks

 

[giadich]

You will need to pass Rnd function a different value each time otherwise you'll get the same result.

 

[mentalhard]

I think i have found solution. Namely i am using where clause and executing the reader object two times with two different random value.

random.Next(1, 2000)

However thanks for the reply