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:
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 CancelStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started