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 distributed system in asp.net?
Which property is used to identify the Page is Post Back in ASP.NET?
0 Answers Sans Pareil IT Services,
what is state management,what is the purpose of it,how it will be implemented in real time?
How will you do windows authentication and what is the namespace? If a user is logged under integrated windows authentication mode, but he is still not able to logon, what might be the possible cause for this? In ASP.Net application how do you find the name of the logged in person under windows authentication?
What is the maximum amount of memory any single process on Windows can address? Is this different than the maximum virtual memory for the system? How would this affect a system design?
when i want to use asp.net configuration for creat users and roles i recived this message: There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: Unable to connect to SQL Server database. when i clicked the choose data source button that give me another message that is this: Use this page to configure how Web site management data such as membership is stored. You can use a single provider for all the management data for your site or you can specify a different provider for each feature. Your application is currently configured to use the provider: AspNetSqlProvider Select a single provider for all site management data Select a different provider for each feature (advanced) ------------------------- and this message was reapeted in other choose again. please help me if u know why i gave that message so i wont can creat my users and roles
What are session state modes? List some of the important session state modes of asp.net.
How will you do Redo and Undo in a TextControl?
What is microsoft windows sharepoint services?
Differnce between Control an View State
You need to retrieve data from a Microsoft SQL Server 2000. Currently you are using an oleDbConnection object to connect to the database server. You need to be able to retrieve the data from the database server in XML format. Which approach would be the most efficient? Select all that apply. Each answer constitutes part of the whole answer. a) Change to the SQL .NET provider. b) Use the ExecuteXmlReader() method of the xxxCommand object c) Use the DOM to create the XML document. d) Use the XmlDocument.Load() method to create the XML Document.
What is sql data source control in asp.net?