Online Examination Code in ASP .NET

                       Here is the code and database of online examination in ASP .NET. The database contains 172 questions related to Safety. Our application picks up 20 questions randomly and gives 600 seconds of time to answer the questions. You can change the no.of questions, answers and the time to be allotted very easily. Just go to GlobalValues.vb file in App_Code folder and change the values as per your requirement. Remember that total questions to be displayed should be X-1, i..e., if you want the system to pick up 20 questions and show it to the user, then the value of "ANSW" will be 19.

    Public Shared ReadOnly TOTQS As Integer = 172 (no.of questions in your database)
    Public Shared ReadOnly ANSW As Integer = 19 (Total no.of questions to be picked up)
    Public Shared ReadOnly ALLOTTIME As Integer = 600 (Time allotted)
    Public Shared ReadOnly ConnString As String = "Data Source=localhost;Initial Catalog=EXAM.MDF;User ID=yourid;Password=yourpwd"

                          As of now the maximum no.of choices for a question is 4, you can increase it by creating more columns in "Test" table with names choice5, choice6 and so on. you can create upto 10 columns according to the code which i have written. You can increase it by changing the code in Qstns.aspx page. To use more than 4 choices you have to Uncomment some of the sections of Qstns.aspx page. Look at the screenshots below

 

            

                  You have to uncomment these three sections depending on the max no.of choices you have in the examination and also remember that you have to create columns in the "Test" table. All the answers to the questions should be stored in the "correct" column of "Test" table. Answer sheets of the participants will be stored in Answers table for your reference. IP Address, PC Logon name of the paticipant, left out time, participation status will be available in Users table. Store the name of the user in "NAM" column of "Users" table. This is not a much complex code, I guess you people will be able to understand it easily. For any queries please contact pkvecc@lntecc.com, All the best.