i want to develope a page for online test using asp.net with c#.net. so, how

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

3 Answers
11407 Views
Chaitanya, Crysalis, CTS, HCL, Sein Infotech, TCS, I also Faced
E-Mail Answers

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

How many types are there session

5 Answers TCS,

14. What are your Future Plans for Swatz Oils GROUP U.K?

0 Answers CSC, Swatz Oils, TCS,

How do you add a javascript function for a link button in a datagrid ?

4 Answers Microsoft,

When you are running a component within ASP.NET, what process is it running within on Windows XP? Windows 2000? Windows 2003?

0 Answers BirlaSoft,

What is web application virtual directory ?

2 Answers Satyam,

define silverlight and advantages ?

3 Answers QA,

What is the difference between Server.Transfer and Response.Redirect?

5 Answers

Can we store PROGID information in database and dynamically load the component ?

1 Answers Digital GlobalSoft, e4e,

Why is string called immutable data type?

0 Answers

How do we ensure view state has not tampered?

0 Answers

what is .net

15 Answers Net Solution,

IN an ASP.NET Web application if there is any error, how can you debug?

0 Answers Siebel,

For more ASP.NET Interview Questions Click Here