Select Random Number from Access Table Using C#

  • Thread starter Thread starter dungdang
  • Start date Start date
D

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

See if the following helps:

http://support.microsoft.com/kb/287682


Paul
~~~~
Microsoft MVP (Visual Basic)
 

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

Similar Threads

Select a Random Number from MSAccess Table Using C# 3
LINQ + .Contains(s) + sp_executesql = big performance problem 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Define number of records 1
MS Access and expression web 1
Random Function for Selecting Records 3
Stored procedure advise 3
MACRO RUN random percentage and copy of column values 1

Back
Top