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 actually returned from server to the browser when a browser requests an .aspx file and the file is displayed?
if we establish the cinnection with connection string tag in web.config file,can i go for encrypt and decrypt with that?
Is react a template engine?
What do you understand from custom control?
Are there resources online with tips on asp to asp.net conversions?
Can we use multiple forms in single asp.net application?
Error : The operation couldn’t be performed because ole db provider sqlncli10 for linked server was unable to begin a distributed transaction.00000110 oledb provider for linked server returned message the partner transaction manager has disabled its support for remote/network transactions. I can able to execute the stored procedure in sql server but when i run the web page getting error like above. I did all the configuration. what is the solution?
Write the different features of a Thread and a Process?
Define view state.
Explain about asp.net caching?
In a webservice, need to display 10 rows from a table. Which is the best choice among datareader or dataset?
what is the difference b/w Asp.net server controls and html server controls in .net?
2 Answers iGate, Profiniti Systems,