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
Answer / varasri
the query for random selection is
select * from tablename order by newid()
Is This Answer Correct ? | 32 Yes | 8 No |
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 |
Answer / ravi
In ORACLE
select * from questions
order by (id * dbms_random.random)
Is This Answer Correct ? | 4 Yes | 5 No |
What are different types of directives in .NET ?
What is reflection and disadvantages of reflection?
Explain difference between friend and protected friend?
What is application state?
Have you used microsoft dataaccess blocks and Exception blocks?
What is difference between session and viewstate?
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.
Is asp.net and .net same?
What is special types forms
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.
What does asax stand for?
What are the differences between application object and session object?