Save quiz Question and Answer in Database in ASP.Net

1) If you are populating question on same page then only it’s better to retain the values in Viewstate till the last question answer attempted.

2) If you want to restore the all selection once user quit from the quiz then no need to save the question answers till user attempt the all the question. In last you can save all the values which you have retain in ViewState if it’s on same page.

3) Its based on your Question Answer Populating and retaining logic as how you are doing.

@kalpesh

I'm using same logic as mentioned in pervious question.

http://www.aspforums.net/Threads/159498/Quiz-Question-Answer-with-dynamic-options-using-C-in-ASPNet/

Thanks

1) You need to retain the Answer value as per selected option on next button click for each question in ViewState as per Question id

2) In Last Where you are showing the Quiz Score there you can Save the details By looping to all the question with saved values for selected answer from Viewstate.

3) So if user quit in between then there is no impact in database as user not completed the exam till the last question so details will not get saved in database until he complete the test also you don’t need to restore any value if use quit the test in between.

@kalpesh

Can you give me small example.

 Thanks

private int result
    {
        get { return (int)ViewState["result"]; }
        set { ViewState["result"] = value; }
    }

 Result table

INSERT INTO [dbo].[ResultTable]
           ([Emp_Id]
           ,[Question1]
           ,[Question2]
           ,[Question3]
           ,[Question4]
           ,[Question5]
           ,[Question6]
           ,[Question7]
           ,[Question8]
           ,[Question9]
           ,[Question10]
           ,[Question11]
           ,[Question12]
           ,[Question13]
           ,[Question14]
           ,[Question15]
           ,[Question16]
           ,[Question17]
           ,[Question18]
           ,[Question19]
           ,[Question20]
           ,[Question21]
           ,[Question22]
           ,[Question23]
           ,[Question24]
           ,[Question25]
           ,[Question26]
           ,[Question27]
           ,[Question28]
           ,[Question29]
           ,[Question30]
           ,[count]
           ,[TestDate]
           ,[TestDateplus])
     VALUES
           (<Emp_Id, varchar(50),>
           ,<Question1, int,>
           ,<Question2, int,>
           ,<Question3, int,>
           ,<Question4, int,>
           ,<Question5, int,>
           ,<Question6, int,>
           ,<Question7, int,>
           ,<Question8, int,>
           ,<Question9, int,>
           ,<Question10, int,>
           ,<Question11, int,>
           ,<Question12, int,>
           ,<Question13, int,>
           ,<Question14, int,>
           ,<Question15, int,>
           ,<Question16, int,>
           ,<Question17, int,>
           ,<Question18, int,>
           ,<Question19, int,>
           ,<Question20, int,>
           ,<Question21, int,>
           ,<Question22, int,>
           ,<Question23, int,>
           ,<Question24, int,>
           ,<Question25, int,>
           ,<Question26, int,>
           ,<Question27, int,>
           ,<Question28, int,>
           ,<Question29, int,>
           ,<Question30, int,>
           ,<count, bit,>
           ,<TestDate, datetime,>
           ,<TestDateplus, datetime,>)

Can you explain from where you are populating question details and from where you need to save? Your question table Structure with answer option relation table and the answer save table structure so can suggest you change in code as well as in design.