Save quiz Question and Answer in Database in ASP.Net

Then your logic is wrong for storing answer details in result table. As there is no any answerId in Option table which you will retain as answerId in Result table. Also if user already attempt the test then only record get inserted so why to add count column if user not attempt the test then there will no any record entry for test.

You need to modify the table definition according to option table also for answer Table. Then you can apply the correct logic in code till then no use to change in code.

@kalpesh

in options table 1 question and four options how I can give answer id in the table can you let me know.

In answer table i used questionid (int) and answer(varchar Datatype)

Thanks

Look the below sample table structure and there test value.

CREATE TABLE OptionTable(QuestionId INT NOT NULL,OptionId INT NOT NULL,Options NVARCHAR(500) NOT NULL)
INSERT INTO OptionTable VALUES(1,1,'LK Advani')
INSERT INTO OptionTable VALUES(1,2,'Manmohan singh')
INSERT INTO OptionTable VALUES(1,3,'Sachin Tendulker')
INSERT INTO OptionTable VALUES(1,4,'N. Modi')
INSERT INTO OptionTable VALUES(2,1,'Delhi')
INSERT INTO OptionTable VALUES(2,2,'Mumbai')
INSERT INTO OptionTable VALUES(2,3,'Kolkata')
INSERT INTO OptionTable VALUES(3,1,'Ricky Pointing')
INSERT INTO OptionTable VALUES(3,2,'Sachin Tendulker')

CREATE TABLE AnswerTable(EmployeeId INT,QuestionId INT NOT NULL,AnswerId INT NOT NULL)
INSERT INTO AnswerTable VALUES(1,1,4)
INSERT INTO AnswerTable VALUES(1,2,2
INSERT INTO AnswerTable VALUES(1,3,2)

@kalpesh

Yes Table design changed but how I can save the Data in Database.

Thanks

Create a class where you can populate the question details and when you sets the question answer and there count you just need to set the answer property as selectedAnswerid value. and in last you just need to loop all the question from property class and have to save the answer value depending on the employeeid and the QuestionId with selected AnwerId.

There is lots of change in your Querstion Population Code which you are storing now as DataTable as property in viewstate.

You need to modify it by creating one class wioth the properties as Questionid,QuestionDescription and answerselected property.

You just need to set the AnswerId when you select answer and continue for next question. and in last youneed to save it according to your viewstate values.