Inserting rows in the specified database table

In this recipe, we will be learning to insert rows into a table. We assume a table called Users consisting of two columns, EmailAddress and Password, already exists in a database called ECommerce.

After entering the email address and password in the respective Line Edit widgets, when the user clicks the Insert Row button, the row will be inserted into the specified database table.

How to do it…

Here are the steps to insert rows into a database table that exists in SQLite:

1. Let's create an application based on the Dialog without Buttons template.
2. Add five QLabel widgets, four QLineEdit widgets, and one QPushButton widgets to the form by dragging and dropping five Label widgets, four Line Edit widgtes, and one Push Button widget on the form.
3. Set the text property of the first four Label widgets to Enter database name, Enter table name, Email Address, and Password.
4. Delete the text property of the fifth Label widget this is established through code.
5. Set...