![]() My_tree.move(row, my_tree.parent(row), my_tree.index(row)-1) Zipcode_label = Label(data_frame, text="Zipcode") State_label = Label(data_frame, text="State") Ln_label = Label(data_frame, text="Last Name") My_tree.tag_configure('evenrow', background="lightblue")ĭata_frame = LabelFrame(root, text="Record")ĭata_frame.pack(fill="x", expand="yes", padx=20)įn_label = Label(data_frame, text="First Name")įn_id(row=0, column=0, padx=10, pady=10)įn_id(row=0, column=1, padx=10, pady=10) My_tree.tag_configure('oddrow', background="white") My_tree.heading("Zipcode", text="Zipcode", anchor=CENTER) My_tree.heading("State", text="State", anchor=CENTER) My_tree.heading("City", text="City", anchor=CENTER) ![]() My_tree.heading("Address", text="Address", anchor=CENTER) My_tree.heading("ID", text="ID", anchor=CENTER) My_tree.heading("Last Name", text="Last Name", anchor=W) My_tree.heading("First Name", text="First Name", anchor=W) My_lumn("Zipcode", anchor=CENTER, width=140) My_lumn("State", anchor=CENTER, width=140) My_lumn("City", anchor=CENTER, width=140) My_lumn("Address", anchor=CENTER, width=140) My_lumn("Last Name", anchor=W, width=140) My_lumn("First Name", anchor=W, width=140) My_tree = ("First Name", "Last Name", "ID", "Address", "City", "State", "Zipcode") My_tree = ttk.Treeview(tree_frame, yscrollcommand=tree_t, selectmode="extended") My_tree.insert(parent='', index='end', iid=count, text='', values=(record, record, record, record, record, record, record), tags=('oddrow',)) My_tree.insert(parent='', index='end', iid=count, text='', values=(record, record, record, record, record, record, record), tags=('evenrow',)) # Create a database or connect to one that existsĬ.execute("""CREATE TABLE if not exists customers (Ĭ.execute("INSERT INTO customers VALUES (:first_name, :last_name, :id, :address, :city, :state, :zipcode)",Ĭ.execute("SELECT rowid, * FROM customers") Delete Database Record With Treeview – Python Tkinter GUI Tutorial #178 When deleting records from any database, you always want to use that records unique id, or primary key, or in sqlite3’s case, the rowid (oid). We just connect to the database as usual, create a cursor as usual, then run one simple SQL command to delete a record with a specific ID. ![]() In this video I’ll show you how to delete a record from our database using the Treeview and entry boxes in our Treebase app.ĭeleting records from the database is pretty simple.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |