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

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;

the On Aug 21, 9:48 am, "ca8...@aspnetlibrary.com"
 wrote:

> 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..

dungdang wrote:

> 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,