Oct-26-2020, 07:47 PM
(Oct-26-2020, 10:19 AM)Larz60+ Wrote: missing commit
no I do not just I want to make the code short for question
here are the all codes
import tkinter as tk from tkinter import * import pyodbc root = tk.Tk() id_id=IntVar() id_entry=tk.Entry(root, textvariable=id_id) id_entry.grid() name_name=StringVar() name_entry=tk.Entry(root,textvariable=name_name) name_entry.grid() get_id=id_entry.get() get_name=name_entry.get() conn = pyodbc.connect('Driver={ODBC Driver 17 for SQL Server};' 'Server=XXXX\SQLEXPRESS;' 'Database=test1;' 'Trusted_Connection=yes;') cursor = conn.cursor() cursor.execute("""INSERT INTO test3 (user_id, user_name) VALUES (?,?)""", get_id, get_name) conn.commit() conn.close() root.mainloop()