Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Internals A Deep Dive Into How Distributed Data Systems Work

Authors: Alex Petrov

1st Edition

1492040347, 978-1492040347

More Books

Students also viewed these Databases questions

Question

What is the difference between Needs and GAP Analyses?

Answered: 1 week ago

Question

What are ERP suites? Are HCMSs part of ERPs?

Answered: 1 week ago