Connecting to a database

In this recipe, we will learn how to connect our Qt 6 application to the SQL server.

How to do it…

Connecting to SQL Server in Qt is really simple:

1. Open Qt Creator and create a new Qt Widgets Application project.
2. Open your project file (.pro), add the sql module to your project, and run qmake like this:

   QT += core gui sql

3. Open mainwindow.ui and drag seven label widgets, a combo box, and a checkbox to the canvas. Set the text properties of four of the labels to Name:, Age:, Gender:, and Married:. Then, set the objectName properties of the rest to name, age, gender, and married. There is no need to set the object name for the previous four labels because they’re for display purposes only:

Figure 12.10 – Setting the text properties

4. Open mainwindow.h and add the following headers below the QMainWindow header:

   #include <QMainWindow>
   #include <QtSql>
   #include <QSqlDatabase...