Save|Open Checklist questions (+100) ¿create a file or load ID?

Hello !,

I have a question that is not how to proceed or explain..

I want to develop a checklist with over 100 questions.
The intention is to create a file to begin creating the draft checklist , which at one point can save the textbox that were already completed. But after that may be loades for completing the empty questions..


Is possible to Create Save file and then open it? Or, create an ID number and can be loaded only questions left unanswered? .. but do not know how this is done ..

What would you recommend for a bestpractice ?. I was reading about saved settings . but development includes many questions and values.

I have Visual Studio 2010 with MySQL database ..

:sick:

Why would you what to create a file when you have a database? Are all the questions in a checked/unchecked format or do some have written answer or multiple choice? Either way you could create one table for the questions and another for the people who take the test and possibly one more for there results. Need more information about what your trying to achieve with this app.

Hi wes4dbt!!

Certainly , it is more due to ignorance about the topic..
The idea is that dev a checklist with only the followings values ​​:
- yes (int)
- no (int)
- other (varchar)

But saved the progress and with the option to loaded when he wants to finish..

How If is possible ?
This is a demo before starting with +100 questions .. Attachment 122647 This function saves the textbox in settings but not how to give to more than 100 questions ..

Code:

---

Public Class Form1

    Private Sub Button2_Click(sender As System.Object, e As System.EventArgs) Handles Button2.Click
        TextBox1.Text = My.Settings.Text

    End Sub

    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
        My.Settings.Text = TextBox1.Text
    End Sub

    Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
        Button2.PerformClick()
        Me.Text = My.Settings.Text
    End Sub

    Private Sub Button3_Click(sender As System.Object, e As System.EventArgs) Handles Button3.Click
        TextBox1.Text = ""
    End Sub
End Class

---

Best Regards!!

I would not use the settings for this, create a table in the database as I mentioned before. It could be very simple table.

Questions table
Fields

PrimaryKey - AutoNumber or ID type
Question Number - int
Question - varchar

For the people who take the test and their answer I would suggest setting up 2 tables - person(parent table)/answers(child table)

Anyway this is whats called a relational database. If you google the subject you will finds lots of example and information.