Displaying record details from database table in Tkinter Treeview when user enters record id

preview_player
Показать описание
00:00 Demo of the script showing record details in Treeview
00:49 Window layout by placing labels and buttons to trigger the function
01:08 Adding Label asking for student id as input
01:56 Adding entry box to receive the student id
03:04 Button to trigger the function to collect and display data
05:20 Adding Label with stringvar to display the record
07:29 Connection to MySQL database using SQLAlchemy
08:33 Function my_details() to trigger when button is clicked.
09:13 Creating parameterized query with student id
12:04 Executing query and getting the record details of student
15:55 Adding Treeview to display row of data
17:26 Adding column headers from table field names
19:30 Inserting student row data to Treeview

Download source code from here

#TreeviewRecordDetails #UserinputID #IdDetails #Treeview #record #StudentTable #studentDetails #plus2net #Tkinter
Рекомендации по теме
Комментарии
Автор

Thank you very much for your help! you are an excellent profesor!

UrsulaRetesHerrera
Автор

Hi How can we add more than one record to the tree view, I have tried but with out any luck Regards Phil

philmillington