Tkinter Treeview to display report based on selection of Month from Combobox from MySQL table

preview_player
Показать описание
00:00 Introduction and demo of Monthly report in Tkinter window
01:17 Creating Tkinter window and Layout
02:15 Adding combobox to Tkitner window with list of Month names
03:53 Adding Label to display SQL
04:47 Adding trace() method to stringvar()
05:13 Adding function my_upd()
06:31 Creating the query using user selection of Month
09:41 Adding Treeview to layout
10:49 Connection to MySQL database
11:40 Crating query to execute with MySQL database
13:23 Executing query and getting column headers
14:36 Adding headers and columns
17:37 Inserting rows to Treeview
21:00 Deleting all rows of Treeview before inserting fresh rows
23:34 Changing the date formats in Query
25:38 Copying sample code to create table with 50 rows of data

Download the source code and copy the table structure with sample data

#ReportMonthly #QueryUserSelection #QueryWithMonth #MatchingMonth #MySQLReport #TkinterTreeview #plus2net #python
Рекомендации по теме
Комментарии
Автор

You are doing excellent boss. Thanks so much. I think I'll learn quite alot from your channel.

yeirivercounty
Автор

Hi Sir, your videos are all really interesting and really helpful as you are always being up with use cases.

I have a clarification, in your Python Gui playlist videos I can see only first 27 videos sequential numbers are there. Rest don't have. If that also updated it would have been good for everyone.

Also please guide me how to prepare for Python interview. cause I have learned some useful and interesting ones related to Tkinter nowadays. But I am not sure since how long I should learn to get start with Interview and what shall be primary requirements expected by recruiter for Python developer. please guide me.

vetrivelr