Question: Im lost, SQLITE3 and the WX LISTCTRL Create a program that reads a table from a database into a wx.ListCtrl. The database will be named

Im lost, SQLITE3 and the WX LISTCTRL

Create a program that reads a table from a database into a wx.ListCtrl. The database will be named college.sqlite and the table is to be named students. A link to a copy of the students data in the form of a CSV file is given later in this document. The CSV file contains a row of 9 heading and then 50 rows of student records. A single record and the proper field names for the table should look like this. The id is the primary key

Your interface will need a wx Frame and a wx ListCtrl and 3 buttons. A display button loads all of the student table into the list control. An insert button will open a wx Dialog that allows the user to enter the 9 data items used for a student record. When the user closes the dialog the new record will be SQL INSERTED to the student's table and the list control re-populated so as to display the inserted record. You also need a close button to close the program.

example output:

Im lost, SQLITE3 and the WX LISTCTRL Create a program that reads

Insert Into List Control Students Last Name First Name Hrs Co..Hrs Att. GPA PtsMajorAdv. ID Email 6 8 inez 2 7 bpalla@tru.ec zrowe@tru.ec avonna@tru. varez seldorodo@tr 2 1 Display Cancel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!