-
Jan 12th, 2015, 01:43 PM
#1
Thread Starter
Junior Member
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 ..
-
Jan 12th, 2015, 02:37 PM
#2
Re: Save|Open Checklist questions (+100) ¿create a file or load ID?
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.
-
Jan 12th, 2015, 03:30 PM
#3
Thread Starter
Junior Member
Re: Save|Open Checklist questions (+100) ¿create a file or load ID?
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 .. savesettings.zip 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!!
-
Jan 12th, 2015, 04:00 PM
#4
Re: Save|Open Checklist questions (+100) ¿create a file or load ID?
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|