Select the row to Edit and update records from MySQL table using Tkinter Treeview

Download the source code from here.

Based on the category the records will be collected from MySQL product table( plus2_products ) and shown inside a Treeview. User can select any row and details of the record will be displayed for edit and update. Once updated ( in MySQL table ) fresh data will be taken from the product table showing the changes.

Details of the functions used in the script.
Collects data from MySQL table and populate the Treeview.

All parts of Restaurant Management are here

Part I is here

Part II : database integration

Part III : Generating Invoice

Part IV Installation of product table

Part V Installation of sale and bill tables

Part VI Generating date wise reports

Part VII Using Combobox for selection of items.

Part VIII Select and edit Product table using treeview

#EditProduct #MySQLEdit #UpdateData #plus2net #python #TreeviewEdit #MySQLQuery

[ab-jv]

The greatest one, thank you for the impressive lecture

[PANDURANG]

you are loosing cursor, it will be not beneficial if you have millions or records