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 the different ASP.NET Application Folders?
asp.net page is a object or not?
what is CLR?
What r the page life cycle in asp.net page?
How would you get ASP.NET running in Apache web servers - why would you even do this?
Types of values mode can hold session state in web.config ?
1 Answers Accenture, Parrot Systems,
14. What are your Future Plans for Swatz Oils GROUP U.K?
0 Answers CSC, Swatz Oils, TCS,
What is the use of web.config file?
Explain the difference between web user control and web custom control?
Is it necessary to create a Windows application or Web application to test a Web service ? Is it must to consume this service?
How to publish website
What Is ASPNET_WP.exe? What Is The Use Of It? In Which Place Inproc Session Stored ? Explain Session State ?
2 Answers Phoenix Technologies,
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)