Display MySQL data in python table :Treeview with horizontal scrollbar

In this video,you will learn how to create a table in python GUI to display MySQL data and also work on the themes and style of Treeview widget. And finally, I have added a horizontal scrollbar to scroll over the table.
Link for Insert and delete rows in Tkinter Treeview with MySQL backend
• How to insert and dele...
Link for how to connect python with MySQL
• How to connect Python ...
Link for text to speech conversion using python
• Text to speech convers...
If you are interested in cryptographic videos, here is the link for cryptography playlist:
• Cryptography
Subscribe for more new videos:
/ @trinitysoftwareacademy
Website: www.trinitysw....
Facebook: / trinitysoftwareacademy
Thanks for your support,
#Trinitysoftware
#treeviewpython #tkinter #scrollbarpython

[@miguelangelgallardovillanu5295]

I was looking information about scrollbar and I have found it thaks you, regards from Spain 🙂

[@Trinitysoftwareacademy]

👍

[@vishaldedavat6835]

best explanation.. helped in my dbms mini project.. gui using python

[@Trinitysoftwareacademy]

Glad that it helped🙂👍

[@Sss-kj1ev]

I was looking for just one line for treeview.and i got that in this vdo..thanks...

[@Trinitysoftwareacademy]

You're welcome

[@marcelromeo2812]

Thank you very much, thanks to you I was able to resolve my error on my scrollbar....

[@Trinitysoftwareacademy]

Happy to help👍

[@marcelromeo2812]

@@Trinitysoftwareacademy Thanks you

[@debendra2010]

thanks a lot bro for your best work

[@kaivalyabhuvad6548]

Very nice explanation Ma'am
And thank you for this video
You made my day

[@Trinitysoftwareacademy]

Thank you and you're welcome

[@ruchi4641]

Thanks mam well explained video 😊😊😊😊👍👌👍👌👍👍👌

[@Trinitysoftwareacademy]

👍

[@faaiidodiineed6924]

Thank you, You helped me a lot

[@Trinitysoftwareacademy]

you're welcome

[@hosseinj5274]

Thank you, very nice. Appreciate sharing it.

[@Trinitysoftwareacademy]

Thank you 👍

[@santhoshkumarbtech1689]

Thank you very much mam 🙏🙏♥️ it is very useful to me now 🙏❤️

[@Trinitysoftwareacademy]

👍

[@cornintime6271]

i wanted to add this as an option to view the table while updating it on my app, but it does not update unless i close and reopen the application.
is there a way to refresh the table using a button named 'refresh', as click it will refresh the table in our application? thank you for the tutorial btw

[@aquibshaikh8611]

Thank you very much, you are an amazing teacher

[@Trinitysoftwareacademy]

Thank you👍

[@samyamoydas7311]

thank you, it works

[@shortstorisforkids]

Hi, i would like to ask if can you make a printable report from the table you made? And if yes, how can you print data from 2 table with a different number of data displayed.

[@dharmawangsa9592]

Thanks Ma'am, working well. hope u have more like and subcriber

[@Trinitysoftwareacademy]

Thank you for the support and wishes. 🙂👍

[@tazulislam2698]

Will this table show more than 5000 rows?

[@PANDURANG99]

what if my data is big like 4-5 lines , how to show in treeview, like new lines data show

[@shyam6206]

how to do the same with labels(horizontal label ) in loop in a frame(frame will show 3 labels at a time and to see rest we have to scroll) with scroll bar(vertical)?---not tree view(I will use tree view in admin part)

[@hasanshaikh5565]

nice video. very informative👌👌

[@Trinitysoftwareacademy]

Thank you

[@gavinbaird1919]

how would you add the xscrollbar with grid()? thank you

[@devarajmanimaranYT]

Hi is there way i don't define column names, rather it do incremental or decrease based on the columns in database

[@takayansmainsidechick6313]

4:08 I would like to add all the records (10+records) in my table so instead of typing 'row[1],row[2]...etc, I have entered the following code
i=0
count=cursor.rowcount #number of records
for row in cursor:
for a in range(count):
tree.insert("",i,text="",values=(row[a]))
i+=1
but this does not work. Is there anyway to retrieve 10+ records (from mysql database) besides using the method in 4:08 ?

[@Trinitysoftwareacademy]

The for loop which I have written will work for all the existing records in the mysql table. I have mentioned 10 records, specific to my example. So, you can use the same loop in 4:08 to retrieve 10+ records.

[@takayansmainsidechick6313]

@@Trinitysoftwareacademy Sorry for the trouble, I have misinterpreted your explanation. I executed the original code and it worked just fine. Thank you for reaching out!

[@Trinitysoftwareacademy]

@@takayansmainsidechick6313 No problem. And you're welcome

[@Karma_9913]

is it ok if I use width1 instead of 'width' as I have already used that as a variable

[@queendreem-gk4is]

thanks

[@ashishtiwari1052]

Thankyou Very much 😊

[@Trinitysoftwareacademy]

👍

[@ashikgrg4356]

Ma'am please make a video on "Fetching data from mysql database randomly"

[@alithandappuram]

TypeError: 'MySQLConnection' object is not iterable , can you help me on this error

[@krajeshwari6799]

Mam how to increase table size

[@gavineshwar9619]

can we increase the size of the table

[@Trinitysoftwareacademy]

Yes

[@عبدالرحمنالعنزي-ت5ن]

Thank u ♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️

[@Trinitysoftwareacademy]

👍

[@sankaranradhakrishnan7905]

how to increase size of table

[@GauthamRaj-wf8kr]

how to move the table

[@nihalthannegedarapremaratn2352]

Great

[@Trinitysoftwareacademy]

👍

[@s.v.prashath7441]

tq so much mam

[@Trinitysoftwareacademy]

Thank you and you're welcome

[@s.v.prashath7441]

@@Trinitysoftwareacademy mam for vertical scroll bar whether same procedure mam?

[@Trinitysoftwareacademy]

@@s.v.prashath7441 yes. It's implemented here
ruclips.net/video/rHwHGeh4jz0/видео.html

[@surajhiremath2199]

Cannot import name'tkk' from tkinter.
Someone with solution?

[@Trinitysoftwareacademy]

Its ttk not tkk

[@garlicz1205]

Where's the code?

[@Trinitysoftwareacademy]

github.com/ChristobelDiana/treeview/blob/main/treeinsertdel.py

[@krajeshwari6799]

Pls reply mam