how to retrive data from database in asp.net

Question

0.00/5 (No votes)

See more:

i have 10 questions in data base and i want to retrive the data database randomly.
the columns are que,a,b,c,d,correct answer.total 6 columns

these are my columns in which questions as well as options and answers are fetched.
now i want to retrive it randomly and display it in design part.so what query i need to write.....

Posted 21-Nov-11 19:56pm

Member 8388026

Updated 21-Nov-11 20:07pm

sachin10d

Add a Solution

3 solutions

Add a Solution

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

Nickos_me · Answer 1 · 2011-11-21T20:02:00

Solution 1

Maybe, simple use query like that:

SQL

SELECT * FROM table ORDER BY RAND() LIMIT 1

Posted 21-Nov-11 20:02pm

Nickos_me

srinivas vadepally · Answer 2 · 2011-11-21T20:04:00

Solution 2

Hi,
RandomSelection1[^]
RandomSelection2[^]

Posted 21-Nov-11 20:04pm

srinivas vadepally

sachin10d · Answer 3 · 2011-11-21T20:06:00

Solution 3

Try this query

SQL

select top 20 percent * from tableName order by newid()

tableName = your table name

Posted 21-Nov-11 20:06pm

sachin10d

how to retrive data from database in asp.net

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

how to retrive data from database in asp.net

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us