Lab Session: Saving data into SQLite: Difference between revisions

From NSB App Studio
Jump to navigation Jump to search
No edit summary
Line 5: Line 5:
# Open LabSqlite.nsx
# Open LabSqlite.nsx
# Update your initialization code in ''Sub Main'' to create a table in the database, if it doesn't exist already.
# Update your initialization code in ''Sub Main'' to create a table in the database, if it doesn't exist already.
# Update your ''btnSave'' click event to instead INSERT records into the table you created in the first step.
# Update your ''btnSave'' click event to INSERT records into the table you created in the first step.
# Update your onshow event for ''frmSaves'' so it SELECTs the entries in an array that's used to populate the list.
# Update your onshow event for ''frmSaves'' so it SELECTs the entries in an array that's used to populate the list.
# Modify your click event for ''lstSaves'' to use the array you populated in the previous step.
# Modify your click event for ''lstSaves'' to use the array you populated in the previous step.

Revision as of 22:52, 13 December 2013

In this lab you will modify your app so you can save historical weather data in SQLite.

Student Outline

  1. Open LabSqlite.nsx
  2. Update your initialization code in Sub Main to create a table in the database, if it doesn't exist already.
  3. Update your btnSave click event to INSERT records into the table you created in the first step.
  4. Update your onshow event for frmSaves so it SELECTs the entries in an array that's used to populate the list.
  5. Modify your click event for lstSaves to use the array you populated in the previous step.