PyQt : Show Data Into QTableWidget From Database.

Database file :
www.file-up.org/wx7q1x2zexw0
gestyy.com/ew5vJ8

[@user-kv3je7fk6v]

Только начинаю работать с PyQt. Я просмотрела множество видео о работе с таблицами, но все так нудно рассказывают и растягивают время, я не могла понять принцип использования. Здесь я ни слова не поняла, но наглядная демонстрация настолько хороша, что я научилась работать с таблицами в PyQt. Потрясающе

[@lyonlai3132]

I think this is the most learner-friendly video of PyQt5-connect-database-then-show-in-tableView I have ever watched, thank you.

[@mindcreativestudios4709]

Searched far and wide for a simple tutorial like this... A BIG THANKS!!! for sharing.

[@mannycalavera121]

Straight to the point, great tutorial

[@bedpetikee]

Nice of you to not edit out your typing mistakes and your reaction to them. It somehow calmed me :D

[@Nuhyamin1]

Thank you so much bro. This helps tremendously

[@merrynet445]

gracefull ,well done ,Thank you !

[@BurlandooSistema]

GREAT tutorial man!

[@emrekucuk172]

thanks for sharing dude. You're the best ! you helped me very much. Thank you again.

[@sinduramkoundinya5615]

thanks for this.....helped me a lot

[@bryantavera6361]

good stuff, worked for me thanks !

[@davidthompson3876]

Excellent tutorial thank you. Hope you do more.

[@endaolaw1182]

thanks for sharing, it's helping me alot

[@aNDy-qh1em]

Awesome, just what expected. Thanks! Just what is the best way to display names of the fields (columns) to keep them frozen on the top?

[@cindyyeon489]

Thank you! Great help for me !!

[@abrahamhassan4044]

This is so helpful!! Ive been looking for this for weeks!

[@arvindthakur2668]

How can a binary image if added in the database be displayed on to QtableWidget. Please let me know will be a great help for me.

[@sanjaynt7434]

Thanks mam for the explanation it helped me a lot

[@PrasadNadiger456]

A helpful tutorial!!

[@nataliejanepacificar7068]

Thanks for this!

[@excellencemichel4875]

Hello ! Thank you very much for this great tutorial. Is it possible to remove the numbers that are on the list on the left by default because that has the fact that there are duplicate numbers with the identifiers.

[@arenmkhoyan]

Thank you my bro

[@zyrosigs4393]

HI thanks for the video, is it possible for the user to enter/edit values in the tablewidget which then update the database?

[@sameerk12982]

Thank you very much for this informative tutorial....you can also set header for table cells using method.... header = ["column_Name1","column_Name2"] self.tableWidget.setHorizontalHeaderLabels(header)

[@yourmommy6849]

yes, you can use...header= ['Id', 'name', 'Lname','phone','address'] after pass to self.tableWidget.setHorizontalHeaderLabels(header)

[@arpitagec9]

How can we add the column names (I dont want the nos. to appear as heading)? Also, if we want to load all the records (without restricting to a few records)?

[@webapplicationguide3798]

Thank You !!

[@rwasta7007]

i will share the db with u on the description. lol

[@apoyenarevici]

Very good explanation! With this example I have written a window showing Sqlite data. Now, I need to show some info in another widget after each itemSelectedChange. I have assigned a variable to choose each row in this table. The first time works fine. But after changing the content of the table the error " has not attibutte "text" " appear because this variable is none. Do you know how to fix this? Thank you.

[@meesteryellow]

Thank you. How would I refresh the table when data changed? For example, I have 2 QComboboxes that sets the arguments of my SQL query, and a button that executes it and adds the data to the table but it doesn't 'refresh' the table.

[@sahiljain7871]

setRowCount(0) and then back to required row count

[@miguelreyesgarcia9975]

Thanks! for this Video!

[@amolmore3093]

Please share the Database link you said you will add in the description????

[@OlaideDspirit]

Thanks for this video have learning Python PyQt from your tutorials and it really make sense please can you do a tutorial on how to store image and retrieve image with pyqt and sqlite3 please

[@OlaideDspirit]

I need to save the picture into sqlite 3 Database and fetch it on a Qlabel i dont understand you

[@OlaideDspirit]

OKAY THANK YOU VERY MUCH I REALLY APPRECIATE IT

[@avinashsingh-zw4qn]

great help thanks

[@hamzazahid1522]

Hey with pyqt5 its giving me error of: tableWidget object has no attribute 'setRowCount'. Any Idea how to resolve this?

[@GregorioHonorato]

Hi, your videos are helping me a lot. Thank you very much. I have a question about your video. How do I make the table row get the id of the table. I need this because at the time I click it it opens a blank record. Thank you very much for your attention and I can not find this solution on the net.

[@Heron31415]

Thank you for your lesson! Can I make dynamic Tableview using as source pivot table aggregated by pandas?

[@MVCoolMaestro]

Thanks ya so much!!!

[@Thoreller]

Well Done!!!

[@jdally9872]

What's the difference between the Table View and Table Widget?

[@jaimsedanos.3442]

how to import data.txt to pyqt5 table widget, it's similar or diffrent. Perhaps, Can you help me with that, please?

[@onlyawareness4608]

Pretty good, but how to change the column headings ?

[@outdoorista9189]

Is this applicable in pymysql db? because it is giving me an error. How can i Fix this? I would really appreciate it

[@omarelfarsaoui5498]

merci mon frère :)

[@manupaimanohara]

please hare the database...u have not in Description

[@technologs8849]

can we view dynamic number list using this

[@rkane9717]

if I wanted to extend this app to swap rows around how could this be done in qt? Including multi-line selection too?

[@snowframe2995]

1 year ago, but still no reply 🙁

[@martinaguila6366]

how about when im using mongodb instead?

[@gustavo6ml]

Obrigado. Thank you.

[@mfatihin8408]

How to create database before load in mainwindow?

[@15837pawimomo]

thank you

[@maximilian4618]

That moment when you forget to insert 'd' Jokes aside, thank you very much for sharing this little bit of information, it is very helpful!

[@siraatsoft1241]

Where is db_conn file. very knowledgeable video. Thanks

[@PitazaBar]

where can I find the code? I see no description for this video

[@drakZes]

You did not share it in the description.

[@SoumilShah]

what if data in database is more than 5 will it expand dynamically ? what i am saying is you entered the row as 5 if if there are 10 values ?

[@ajaysatbhadre9090]

G

[@ajaysatbhadre9090]

Yes, It is dynamic as many as rows you have in table

[@leeleelee229]

Thank you for the good video. I don't know if you can read this comment since it was a long time ago, but I have a question. I followed your video and there was an error such as sqlite3.operationalerror: year "-": syntax error. Do you know the solution? I'm in a hurry. Thank you so much.

[@lavizlay]

A problem I generally have; My 'connect' queries are not working. Neither 'sqlite connect' nor 'clicked connect'. Can you help me?

[@fatihislgan7437]

thanks bro

[@marcdalmaso8540]

The video shows editing of the file created by Qt Designer: It says in Red at the beginning of the file that it should NOT be edited, and indeed it shouldn't! Instead you must create a main.py file and import it.

[@juleswinnfield1437]

For anyone reading this. You CAN edit this file, it's just good practice to import it externally as it will overwrite your logic when updating the UI.

[@alexgutz5450]

I cannot try the program since the database file is SETUP.EXE and the antivirus is saying there is a trojan horse. I have you can just attach the database file.

[@mohamedriedwaanbegg6009]

import sys ............. the import sys goes dimmed also TypeError: connect() got an unexpected keyword argument 'host' mydb = mysql.connector.connect(host='localhost', user='riedwaan', passwd='password') (host='localhost', user='riedwaan', passwd='password' becomes highlighted please help. Im stuck

[@heenachakradhar7972]

whats there in my db file

[@nataliejanepacificar7068]

Can you do a video with CSV files?

[@robinrai341]

i have following error Error 2] The system cannot find the file specified so how to solve?

[@fuadroshan2704]

create a db file first

[@pragatigupta9828]

i got error "Python has stopped"

[@Gogeeish]

Hi!Can can you show how to save data into sqlite table? And how to delete rows?

[@sahiljain7871]

connect to sql - kzbin.info/www/bejne/aqbUm42uja6AeMk delete table rows - Qtablewidget.setRowCount(0)

[@catsandmusic4635]

where's the db file?

[@AbhishekSharma-uy1zv]

I am confused in the above error what to do with that plzz help plzz

[@selinavc-]

CAN WE TAKE THE DATA FROM POSTGRESQL WİTH THİS WAY

[@ACHALAMI]

TypeError: selectedItems(self): too many arguments

[@rupampriya2851]

can i have the code for showing the table from database into tkinter window

[@rupampriya2851]

plzzz help me out from this

[@tomaszdziurman2274]

Hello, how this it looks when i use MySQL?

[@ajaysatbhadre9090]

Sure, soon I will publish new video about that!

[@OlaideDspirit]

This is the error i receive when trying to implement this tutorial import QtWidget ImportError: No module named QtWidget

[@ahmedemad9464]

you should have PyQt5 to import QWidgets

[@suganthiganesh6101]

Hi, Thank you. Great . Can you make a GUI for matrix multiplication for user input?

[@ajaysatbhadre9090]

Yes I can!

[@suganthiganesh6101]

@@ajaysatbhadre9090 Hi, Please Explain how to create it.

[@ajaysatbhadre9090]

You can achieve this by QTableWidget, you can edit values in table or it can be use as a input fields for matrix multiplication. When user change value in cell you will get trigger ( change event ) then you can identify which cell is change and it's new value and perform operation on matrix.

[@suganthiganesh6101]

​@@ajaysatbhadre9090 I have some doubts. can I get your email id?

[@m.furkanyolal6952]

Hi Ssj6; I have 2 columns and so many rows (nearly 10.000) in my database. My program is to slow to load this data. How can i load faster?

[@ajaysatbhadre9090]

You should use pagination. Load records page by page. Instead of fetching all 10000 records at once fetch them 100 on first page and next 100 on second page so on..

[@m.furkanyolal6952]

@@ajaysatbhadre9090 Thank you, i will try it.

[@m.furkanyolal6952]

@@ajaysatbhadre9090 Hello again, I can't find any good source for pagination. Can you send me a example or source?

[@juleswinnfield1437]

Christ. I wish the code would be put in the description -_-

[@balajikshirsagar921]

database is not getting downloaded i tried too much

[@ajaysatbhadre9090]

drive.google.com/file/d/1pA4AzdRchmcUtLfmDCZEqGAwRC7yBdek/view?usp=sharing

[@sufijahan1573]

Vl u plz send me d database to load database into table

[@codewithelyanan6536]

Great Tutorial but, the file like have expired.

[@ajaysatbhadre9090]

Will upload to Google Drive soon.

[@AbhishekSharma-uy1zv]

Error-'Ui_MainWindow' object has no attribute 'tabelWidget' Plzz sir reply for my error

[@ajaysatbhadre9090]

It seems you have made spelling mistake in self.tableWidget. you wrote it 'tabelWidget' please check it.

[@rodrigocolombo5414]

how can do this in PyQt4 ?????

[@piyushranjansahoo9830]

File is not available in that link. Please send me

[@ajaysatbhadre9090]

Sorry for inconvenience, but files are there you need to skip ads then you can download it

[@piyushranjansahoo9830]

@@ajaysatbhadre9090 thanks for your reply. I had tried to do that but it didn't work

[@ajaysatbhadre9090]

drive.google.com/file/d/19okXXpo3NfjaPaNjqiHdqisi4y3eARiJ/view?usp=sharing

[@outdoorista9189]

Traceback (most recent call last): File "criminal_list.py", line 21, in loadData for row_number, row_data in enumerate(result): TypeError: 'int' object is not iterable Please help

[@asimrehman4475]

@ Vince Novem how you can solve this problem coz I also stuck in this problem... Traceback (most recent call last): File "main.py", line 33, in load_data for row_number, row_data in enumerate(data): TypeError: 'int' object is not iterable

[@ajaysatbhadre9090]

It seems data variable is not iterable, the problem is data variable here. Please check it's value.

[@outdoorista9189]

Thanks for your help guys, thou I already graduated a year ago. Can't remember this problem now.

[@catsandmusic4635]

i want to kiss ur head thank u

[@neo92vip]

Warning: All changes made in this file will be lost.... Never edit that file. You need to create separate class and promote the object to that class... You are giving bad design practises.

[@drakZes]

Doesn't work and he doesn't explain anything so I can't learn anything from this.

[@davidledieu2399]

worked for me and I learned a lot?