PyQt5 QTableWidget tutorial: Load data from SQL table into Table Widget [Python, SQLite, PyQT5]

Load data from SQL table into PyQt5 QTableWidget. Use SQLite with Python and PyQt5. Learn how to query from the SQL table and load the data into a Table Widget, or QTableWidget with Python PyQt5. Display data in your Table Widget.

In this video, you will:
-Work with PyQt5 and QtDesigner
-Use QTableWidget or PyQt5 Table Widget
-Query data from an SQL table
-Use SQLite with Python
-Display data in the table widget
-Create QTableItem
-Add QTableItem

Source code:

For more info:

For suggestions or comments:

*************
**Tags**
PyQt5
Python SQLite
SQLite Tutorial
SQLite Queries
PyQt5 tutorial
PyQt5 module
PyQt5 Designer
QtDesigner
Qt GUI tutorial
QTableWidget
PyQt5 Table Widget

[ishudshutup]

Yes yes yes, would love to see this series continued with more advanced queries based on user selections! Thanks so much for these videos, very helpful!!!

[alicefreischmidt]

love love love your videos, absolutely saved my coursework, so well explained, THANK YOU

[polagergesyounan]

I was waiting this video thank you❤️❤️❤️
You are the best instructor❤️

[georadical]

Hi Hala, your tutorials are easier than others on Youtube and in books, definitely!!... Congratulations!!

[dantealonso]

Thanks a lot, that is what exactly I was searching for!

[pin]

Thank you so much, I've been looking for video like this for so long

[cristianalvarez]

Muchas gracias, muy bien explicado!!!

[xlobo]

While watching your tutorial, I know my empty brain is filling up.
You teach so well that it's easy to understand. ❗❗❗
... And every time I heard your lovely voice, it make me smile and laugh. 💚🧡❤

[sekiro_]

i did the same thing you did but with sql server database
ty so much

[Scanito]

Hey Hala, thanks so much for this great tutorial. Clear and straight to the point. For my project, I have been facing a problem that still cannot resolve: One of my columns (imported as a string from SQLite) represents a date. Format is MM/dd/yyyy. I am able to use the TableWidget sort tool to correctly sort by means of a Qt.DisplayRole. However, for clarity purposes, I need the date to be displayed as dd/MMM/yyyy. How can I implement this to work on the QTableWidget? I will highly appreciate your comments!

[mattneed]

please please more :) this is so informative!!! please keep this program going :) would love more tutorials on this like the dropdowns your mentioned!

[marciongolo]

Hello its possible to use QTableWidget to insert, modify and delete data?

[danmusser]

Great Video!! Is there a way to modify the code to change the alignment for certain columns? It looks like the default alignment is left, but there are times when you might want a center alignment on certain columns. Thanks!!

[wickedblue]

would it be the same way putting an excel spreadsheet into the QTableWidget? I cant find information on this. I do love your videos and they have helped me a ton!!! ty

[idonotcomplyrevolution]

your really good at this! please more videos on the subject of database tables in pyqt5/6!!! slow down and breath though!!!! and get a microphone that focuses on your voice and cancels out everything else, apart from that your awesome!!

[adeniyiadewumi]

Pls can you do a video about the last thing you said about showing the details of the country

[gyanamshah]

Can we use Mysql database instead of sqlite to import into pycharm or any other text editors such as vscode or etc?
Kindly explain to me

[myfridayproject]

at 12:30 - Instead of tablerow, why not use enumerate? For example change your for loop to the following: for tablerow, row in Python would automatically provide the rownumbers for you.

[pratikhonnakore]

Hello, I am using MacOS platform, python, PostgreSQL database and pyqt5 for my application development. I am using QSqlDatabase to add the database. The application is packaged with pyinstaller works fine on developer's machine but after deploying to end user's machine the error pops up "Driver not loaded". Could you provide insights on this?

[mohammedalbazi]

thank u, how can i print the data in the table using the printer(A4), pls