UU4dPR83

1from tkinter import ttk
2import tkinter as tk
3import sqlite3
4
5
6def connect():
7    conn = sqlite3.connect("TRIAL.db")
8    cur = conn.cursor()
9    cur.execute("CREATE TABLE IF NOT EXISTS profile(id INTEGER PRIMARY KEY, 
10First TEXT, Surname TEXT)")
11    conn.commit()
12    conn.close()
13
14
15
16def Insert():
17    conn = sqlite3.connect("TRIAL.db")
18    cur = conn.cursor()
19    fr=cur.execute("INSERT INTO profile (First, Surname) VALUES(?, ?)", 
20    (first_text.get(), surname_text.get()))
21    conn.commit()
22    for items in fr:
23        tree.insert('', tk.END, values=items)
24
25    conn.close()
26
27
28
29connect()  #  this to create the db
30
31
32root = tk.Tk()
33root.geometry("400x400")
34
35tree= ttk.Treeview(root, column=("column", "colunn1"))
36tree.heading("#0", text="NUMBER")
37tree.heading("#1", text="FIRST NAME")
38tree.heading("#2", text="SURNAME")
39tree.pack()
40
41
42first_text = tk.StringVar()
43e1 = tk.Entry(root, textvariable=first_text)
44e1.pack()
45surname_text = tk.StringVar()
46e2 = tk.Entry(root, textvariable=surname_text)
47e2.pack()
48
49b1 = tk.Button(text="add data", command=Insert)
50b1.pack(side=tk.BOTTOM)
51
52root.mainloop()