random values from db in c#

Question

How can I retrive random random ItemIDs from the list of existing ItemIDs in ItemID column intge db, given below is the sqlcommand I've used.

(SqlCommand RetrieveComm =new SqlCommand("SELECT * FROM item_k WHERE ItemID='" +intGetRequest+ "'", searchCon))

thanks,

Eoin Campbell · Accepted Answer · 2009-05-24 15:01:03Z

2

Is the itemID column in the database, a contiguous list of numbers ?

If so, you can just do...

Random r = new Random();
int x = r.Next(1, MAX_ID_FROM_DB);

answered May 24, 2009 at 15:01

Eoin Campbell

44.4k18 gold badges107 silver badges161 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Taryn · Accepted Answer · 2013-11-17 14:21:39Z

1

You have not specified which RDBMS you are using.

If you are using SQL Server, this will return N random rows:

SELECT TOP N    
    SomeColumn 
FROM     
    SomeTable
ORDER BY     
    CHECKSUM(NEWID())

Taryn

249k57 gold badges374 silver badges409 bronze badges

answered May 24, 2009 at 15:02

Mitch Wheat

302k44 gold badges482 silver badges552 bronze badges

I didnt get your code! I need to get the itemIDs as well as other values.

So SELECT TOP N * FROM item_k ORDER BY CHECKSUM(NEWID()), no?!