Displaying rows in the specified database table

In this recipe, we will be learning to fetch rows from a given database table and display them in tabular format via the Table widget. We assume a table called Users consisting of two columns, EmailAddress and Password, already exists in a database called ECommerce. Also, we assume that the Users table contains some rows in it.

How to do it…

Follow this step-by-step procedure to access rows from the database table in SQLite:

1. Let's create an application based on the Dialog without Buttons template.
2. Add three QLabel widgets, two QLineEdit widgets, one QPushButton, and one QTableWidget widget to the form by dragging and dropping three Label widgets, two Line Edit widgets, one Push Button widget, and a Table widget on the form.
3. Set the text property of the two Label widgets to Enter database name and Enter table name.
4. Delete the text property of the third Label widget because its text property will be set through code.
5. Set the text property of the push...