![]() ![]() Remove_all_button = Button(button_frame, text="Remove All Records", command=remove_all) Update_button = Button(button_frame, text="Update Record", command=update_record) My_em(selected, text="", values=(fn_entry.get(), ln_entry.get(), id_entry.get(), address_entry.get(), city_entry.get(), state_entry.get(), zipcode_entry.get(),))īutton_frame = LabelFrame(root, text="Commands")īutton_frame.pack(fill="x", expand="yes", padx=20) My_tree.move(row, my_tree.parent(row), my_tree.index(row)+1) 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)", Then we’ll redesign our Treeview to pull the data from the Database instead of that python list. In this video we’ll create a customers Table and add all of our dummy data to it. We’ll be using SQLite3 for the database, but later we’ll swap out MySQL (it’s easy!). Up until now we’ve been pulling dummy data from a python list in our program, but now we want to pull the data from our Database. In this video we’ll connect our Treeview app to a SQLite3 database. ![]()
0 Comments
Leave a Reply. |