Lab Session: Saving data into SQLite: Difference between revisions

From NSB App Studio
Jump to navigation Jump to search
No edit summary
m 4 revisions
 
(One intermediate revision by one other user not shown)
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.

Latest revision as of 06:24, 7 January 2014

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.