从SQL表填充DataGridView数据，并从不同的SQL Server表填充GridView ComboBox

import pyodbc
import tkinter as tk
from tkinter import ttk
from tkinter import messagebox

# 连接到SQL Server数据库
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=服务器名称;DATABASE=数据库名称;UID=用户名;PWD=密码')

# 执行SQL查询并获取数据
cursor = conn.cursor()
cursor.execute('SELECT * FROM 表名')
data = cursor.fetchall()

# 创建一个Tkinter窗口
window = tk.Tk()

# 创建一个DataGridView控件并填充数据
datagrid = ttk.Treeview(window)
datagrid['columns'] = ('Column1', 'Column2', 'Column3')
datagrid.heading('#0', text='ID')
datagrid.column('#0', width=50)
datagrid.heading('Column1', text='Column 1')
datagrid.column('Column1', width=100)
datagrid.heading('Column2', text='Column 2')
datagrid.column('Column2', width=100)
datagrid.heading('Column3', text='Column 3')
datagrid.column('Column3', width=100)

for row in data:
    datagrid.insert('', 'end', text=row[0], values=(row[1], row[2], row[3]))

datagrid.pack()

# 创建一个GridView ComboBox列并填充数据
combobox_column = ttk.Combobox(datagrid, values=['Table1', 'Table2', 'Table3'])
datagrid.heading('#4', text='ComboBox Column')
datagrid.column('#4', width=150, anchor='center')
datagrid.set('#4', 'Table1')  # 设置默认值为Table1

def on_combobox_select(event):
    selected_item = datagrid.selection()[0]
    selected_table = datagrid.set(selected_item, '#4')
    messagebox.showinfo('Selected Table', selected_table)

datagrid.bind('<<TreeviewSelect>>', on_combobox_select)

# 运行窗口主循环
window.mainloop()