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

Life cycle of ASP.NET page when a request is made ?

4 Answers   MMTS,


Explain what is event bubbling?

0 Answers  


When working with ASP.Net server controls, it is important to use the right event handlers to capture the event for the application to function properly. What event would you use to capture the selection of a new item in a DropDownList control? a) The Click event. b) The SelectionChanged event. c) The SelectionIndexChanged event. d) The ChangedSelection event.

4 Answers   Syntax Softtech,


What are session variables?

2 Answers   Microsoft,


Types of store procedure in Sqlserver?

3 Answers  






Explain about the Class view window?

0 Answers  


What is a session government?

0 Answers  


What are the elements of a website?

0 Answers  


Why asp.net is better than php?

0 Answers  


what is .net

15 Answers   Net Solution,


Which is the parent class of the ASP.NET server control?

0 Answers   Sans Pareil IT Services,


4. How do you plan to achieve these goals?

7 Answers   Burger King, Latest, Swatz Oils,


Categories