Select a Random Number from MSAccess Table Using C#

[dungdang]

Hello,
I want to use C# to select a random number from MS Access database
table.
<SELECT TOP 1 userID FROM users ORDER BY NEWID()> seem to work only
with SQL Server.

dungdang

 

[ca8msm]

You may be better off asking directly in an Access group, however, you
could do this directly in your Access query by using the RND function
in conjunction with a calculation on a field e.g.

SELECT TOP 1 Rnd(Len([LastName])) AS Expr1, LastName
FROM Employees
ORDER BY Rnd(Len([LastName])) DESC;

 

[dungdang]

the On Aug 21, 9:48 am, "(e-mail address removed)"

You may be better off asking directly in an Access group, however, you
could do this directly in your Access query by using the RND function
in conjunction with a calculation on a field e.g.

SELECT TOP 1 Rnd(Len([LastName])) AS Expr1, LastName
FROM Employees
ORDER BY Rnd(Len([LastName])) DESC;

I've this method also, on the Access it works fine..but on C# code
(WinForm), it keeps constatntly picking the same number again and
again..

 

[DC]

Hello,
I want to use C# to select a random number from MS Access database
table.
<SELECT TOP 1 userID FROM users ORDER BY NEWID()> seem to work only
with SQL Server.

dungdang

Do you use the "randomise" function befor using RND? if not then you
will always get the same "random" number as you are not getting the
clock to seed the RND function.

Luck,