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:
github.com/codefirstio/PyQt5-...
For more info:
Install and Setup PyQt5 and Qt Designer: • Install and Setup PyQt...
Styling PyQt5 Widgets: Using CSS with PyQt5 in QtDesigner: • Styling PyQt5 Widgets:...
PyQt5 QTreeWidget tutorial: Load data, organize tree, access elements and parents [Tree Widget]: • PyQt5 QTreeWidget tuto...
For suggestions or comments:
My email: [e-mail]
*************
*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!!!

[@georadical100]

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

[@alicefreischmidt1264]

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

[@dantealonso7174]

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

[@polagergesyounan27]

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

[@8pin119]

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

[@xlobo9822]

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. 💚🧡❤

[@pauldivers]

Great tutorial. Keep them coming.

[@cristianalvarez2493]

Muchas gracias, muy bien explicado!!!

[@oscarAL]

Increíble vídeo!!!

[@NhuNguyen-vl7ul]

Thank You for Your sharing !

[@mattneed111]

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

[@Simpotyga]

Thanks a lot👍

[@sekiro_19]

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!

[@mdibrahimayaz6626]

yes please make more content on pyqt

[@danmusser5280]

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!!

[@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!!

[@dorajeshotmailcom]

Thank you

[@mohammedalbazi9949]

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

[@myfridayproject3257]

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

[@marciongolo]

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

[@pratikhonnakore1653]

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?

[@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

[@wickedblue3218]

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

[@adeniyiadewumi4823]

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

[@lloydyu24]

Is there a difference between mySQL and SQLlite implementation?

[@hiwab41]

How can i make search filter with this?

[@lightning6668]

How can we add feature like double clicking on a row will send it's data to QlineEdit?

[@Tri_3D]

yes i need this as well

[@fritzsamuelchery1609]

how can I disable the resize column

[@brunovinicius5696]

How did i seach a row whith a qlineedit?

[@TheCybrixx]

mine just return nonetype TypeError: 'NoneType' object is not iterable

[@comoentroche]

Hi, if i have 200k records in my table using for "it takes a long time" there is a way to load the table without using for or while

[@ac_youtube134]

How did you manage I have same problem :(

[@PANDURANG99]

filters?

[@slpriyavarshini7198]

I am getting Attribute error as 'MainWindow' object has no attribute 'tableWidget'. Could any one help with it

[@jeddysouev6210]

Hi, Hala I want to insert datatype double in row but it is not possible with QTableWidgetItem : argument 1 has unexpected type 'float' .Can you help me subclassing QTableWidgetItem for doing this ? Thank You

[@TheJacklwilliams]

Hala, I gave a thumbs up for the content as it helped me greatly. However, I was tempted not to as there are some great responses below with questions. You've not responded to ANY of them as I see. Just a critique (not trolling) but interacting with your viewers is quite an important part of hosting a channel. Obviously you can't respond to EVERYONE and some posts, well there isn't a response for but....

[@kurdishsha1635]

can i ask where are u from

[@HassaballahIbnAdef]

System email Qt creator

[@septimusseverus252]

Thank you