Click here to Skip to main content
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 4: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 OriginalGriff 390
1 Jochen Arndt 150
2 Richard MacCutchan 135
3 DamithSL 95
4 Garth J Lancaster 90
0 OriginalGriff 6,045
1 DamithSL 4,601
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,260


Advertise | Privacy | Mobile
Web02 | 2.8.141220.1 | Last Updated 11 Aug 2012
Copyright © CodeProject, 1999-2014
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