add radiobutton values to DB

I think that what you are saying is that you need to write a program that gives a test; does that sound correct so far? Your program will show each question with four possible answers, then at the end it will compare the answers to the correct answers, correct?

I don't know what you mean by "store result in database"; do you need to store all the answers that the person taking the test provided or do you just need to store the number correct or something else?

I think that the table of correct answers just needs to have two columns. One column for the question number and another column for the correct answer. The answer will be a number from zero to 3 or from 1 to 4.

In the form that gives the test, you will have four Radio Buttons inside a Group Box. Radio Buttons must be inside a Group Box in order for Windows to know that they are related. You can use the RadioButton.Checked property to determine which is checked; only one RadioButton inside of a specific Group Box can be checked. So then you can compare the number of the RadioButton (0 to 3 or 1 to 4) to the correct answer corresponding to the question.

thank you niki for your reply. I am begginer with programmimg. My problem is:

I have 20 driving test questions and every question has four answer(radio button).User will be able to choose only one answer and these answer will store to a DB when they will click next button. After finishing the exam , when user will click the finish button ,user's  answer will compare with correct answer which is stored in the data base before and it will show how many questions are correct and how many are wrong and user score.

plz don't mind for my lack of knowledge in this field cause i am very new in this field.

I read your reply , although i didn't understand how many table i need to create ( 2 or 3 tables).

According to ur answer---
Method 1: I need to create only one table-- right?
I need 21 columns-- one for User_id and 20 for 20 questions--am i right?

How to store radiobutton values to the table of the db when user will click the next button.
plz help.

Method 2:

I need to create two table-- one is Patterntable and another one is resulttable.


Do you have any code or project or example related to this problem?

Hi Ever green,
 
Your question is not very clear for me. As I understand, you want to store the result in the database.
 
1st method is designing your table with following columns.
user_id   - int
question1  - int
question2 - int
etc..
 
 
2nd method
Create two tables:
1st one:
Pattern table:
pattern_id - int
pattern - varchar (this column will display the pattern like 13245 )
etc..
 
 
Result table:
user_id - int
pattern_id - int
This table forms a foriegn key relation ship with the first table.
 
 
If your problem is  not answered let me know. If it is answered please accept my answer.