1. Categories >> Software >> Microsoft Related >> ASP.NET
  2. Suggest New Category

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....

Question Posted / hariprasad

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

Why is mvc better than asp.net?

0 Answers  

What is the difference between file-based dependency and key-based dependency?

0 Answers  

Less than one page, how many windows will you be able to maintain?

0 Answers   Atos Origin,

Is there any limit for query string? Means what is the maximum size?

0 Answers  

Where does the Web page belong in the .NET Framework class hierarchy?

1 Answers   Perot Systems, Visual Soft,




What is view state and how it works in asp net?

0 Answers  

What is the maximum timeout we can set for Cookies?

0 Answers  

In which event of page cycle is the viewstate available?

0 Answers  

Are cookies stored on server or client?

0 Answers  

Where are session variables stored?

0 Answers  

Can we use MSSql as backend in asp.net...if yes then How.?

0 Answers   MCN Solutions,

What is pre-init event in ASP.NET 2.0 page life cycle?

2 Answers   Fulcrum Logic,

For more ASP.NET Interview Questions Click Here
Categories