Programming and Database DB Browser

import tkinter as tk
from tkinter import ttk
import sqlite3

# ====================
# Database
# ====================
conn = sqlite3.connect("C:/python/mydb.db")
cursor = conn.cursor()

# ====================
# GUI
# ====================
app = tk.Tk()
app.title("รายชื่อนักเรียน")
app.geometry("500x300")

# ====================
# Table
# ====================
columns = ("id", "name", "faculty")
tree = ttk.Treeview(app, columns=columns, show="headings")

tree.heading("id", text="StudentID")
tree.heading("name", text="StudentName")
tree.heading("faculty", text="FacultyID")

tree.column("id", width=80, anchor="center")
tree.column("name", width=200)
tree.column("faculty", width=100, anchor="center")

tree.pack(fill="both", expand=True, padx=10, pady=10)

# ====================
# Load Data
# ====================
cursor.execute("SELECT StudentID, StudentName, FacultyID FROM student")
for row in cursor.fetchall():
    tree.insert("", tk.END, values=row)

app.mainloop()
conn.close()