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 is the difference between user control and custom control?
Every Validation controls have same option ?
How to do Forms authentication in asp.net?
What is difference between Fragment Caching and Page Caching in ASP.NET?
What is the significance of proxy user?
Can I have a unique key as foreign key?
What is route in web api?
What are the different properties of server control that exists?
what if we delete web.config or machine.config? will a website work if we delete webconfig....or if we delete machine config?
Types of caching. How to implement caching?
How do you bind array to gridview? Will it works?
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.
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)