Results 1 to 4 of 4

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

  1. #1

    Thread Starter
    Junior Member feroguz's Avatar
    Join Date
    Aug 2013
    Posts
    22

    Question 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 ..


  2. #2
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,195

    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.

  3. #3

    Thread Starter
    Junior Member feroguz's Avatar
    Join Date
    Aug 2013
    Posts
    22

    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!!

  4. #4
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,195

    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
  •  



Click Here to Expand Forum to Full Width