Click here to Skip to main content
11,705,451 members (59,177 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: selection
i've data on table in one column and want to select one data from table randomly while loading a page on ASP.NET 4.0 C# textbox. how to do it
Posted 11-Aug-12 3:35am
Comments
Wes Aday at 11-Aug-12 9:43am
   
Try using the Random class.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You didn't mention if you want to do this with a SQL query or in code or something else, but if you want to use SQL and you have SQL Server then one way to select a random row is
SELECT TOP 1 * FROM YourTable ORDER BY NEWID()
  Permalink  
Comments
creatives.system at 11-Aug-12 10:18am
   
But it's not working on Access Databse
Mika Wendelius at 11-Aug-12 10:25am
   
So you use Access database. Haven't tried it but you could try something like
SELECT TOP 1 * FROM YourTable ORDER BY RND
Wes Aday at 11-Aug-12 11:23am
   
You need to provide all relevant information if you expect good answers to your question. Where in your question did you say you were using am Access database? Or even a database at all?
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Thank you Mika, Wendelius, Wes Aday for your good response. It's solved now
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 500
1 OriginalGriff 269
2 CPallini 82
3 ppolymorphe 68
4 Inimicos 60
0 OriginalGriff 9,053
1 Sergey Alexandrovich Kryukov 8,347
2 CPallini 5,189
3 Maciej Los 4,726
4 Mika Wendelius 3,626


Advertise | Privacy | Mobile
Web04 | 2.8.150819.1 | Last Updated 11 Aug 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100