i want to develope a page for online test using asp.net
with c#.net. so, how to insert the questions in the
database sqlserver2000 and how to pick the questions
randomly when user login for test. plz send the code for
this....

Answers were Sorted based on User's Feedback



i want to develope a page for online test using asp.net with c#.net. so, how to insert the questi..

Answer / varasri

the query for random selection is
select * from tablename order by newid()

Is This Answer Correct ?    32 Yes 8 No

i want to develope a page for online test using asp.net with c#.net. so, how to insert the questi..

Answer / raju

by using RAND(value) u can get the random Questions....like
below


Select * from table1 where ID=(5*Rand()+1)

Is This Answer Correct ?    16 Yes 6 No

i want to develope a page for online test using asp.net with c#.net. so, how to insert the questi..

Answer / ravi

In ORACLE
select * from questions
order by (id * dbms_random.random)

Is This Answer Correct ?    4 Yes 5 No

Post New Answer

More ASP.NET Interview Questions

What are different types of directives in .NET ?

1 Answers  


What is reflection and disadvantages of reflection?

6 Answers   Microsoft,


Explain difference between friend and protected friend?

0 Answers  


What is application state?

0 Answers  


Have you used microsoft dataaccess blocks and Exception blocks?

1 Answers   Microsoft,






What is difference between session and viewstate?

0 Answers  


what is advantage of developing in asp.net.why the same can't be developed in Java or other web developemnt tool.what are advantages of developers.

4 Answers   IBM,


Is asp.net and .net same?

0 Answers  


What is special types forms

0 Answers   MCN Solutions,


Could u send me the answer for this question as soon as possible. Im using 'System.net.mail.mailmessage' namespace for sending a mail from my application. What should I mention in 'system.net.mail.mailmessage.to' property and What should I mention in 'system.net.mail.mailmessage.from' property.

1 Answers  


What does asax stand for?

0 Answers  


What are the differences between application object and session object?

0 Answers  


Categories