如果您运行此代码,您将看到它将生成一个窗口,其中包含两个下拉框和一个按钮。当您从第一个下拉框中选择一个值时,它将在第二个下拉框中反映!这是需要解决的问题
注意:要使此代码清晰地运行,您需要创建一个表并向其中添加少量记录,至少两行两列。这样就可以填充下拉框
import tkinter as tk
from tkinter import ttk
from tkinter import messagebox
import pandas as pd
import sqlite3
# Creating tkinter window
conn = sqlite3.connect('test.db')
print('Opened Database successfully');
tempAge = []
Salary = []
cursor = conn.execute('''Select * from Company''')
for row in cursor:
tempAge.append(row[2])
Salary.append(row[4])
data_dict = {'name': pd.Series(tempAge), 'age':pd.Series(Salary)}
dframe = pd.DataFrame(data_dict)
window = tk.Tk()
window.title('Combobox')
window.geometry('500x250')
# label text for title
ttk.Label(window, text="GFG Combobox Widget",
background='green', foreground="white",
font=("Times New Roman", 15)).grid(row=0, column=1)
# label
ttk.Label(window, text="Select the Age :",
font=("Times New Roman", 10)).grid(column=0,
row=5, padx=10, pady=25)
# Combobox creation
n = tk.StringVar()
agechoosen = ttk.Combobox(window, width=27, textvariable=n)
salchoosen = ttk.Combobox(window, width=27, textvariable=n)
agechoosen['values'] = (tempAge)
salchoosen['values'] = (Salary)
ageVar=''
salVar=''
def salComboSelect():
if salchoosen.current()==-1:
s=0
else:
salVar = salchoosen.get()
messagebox.showinfo('Message',str(salVar))
def comboselect():
if agechoosen.current()==-1 and salchoosen.current()==-1:
s=0
else:
ageVar=agechoosen.get()
salVar = salchoosen.get()
tempStr = str(ageVar)+" & "+str(salVar)
messagebox.showinfo('Message',str(tempStr))
# print(monthchoosen.current(), monthchoosen.get())
button = ttk.Button(window, text='Submit', command=comboselect, width=20)
ttk.Label(window, text="Select the Age :",
font=("Times New Roman", 10)).grid(column=0,
row=5, padx=10, pady=25)
agechoosen.grid(column=1, row=5)
salchoosen.grid(column=1, row=6)
button.grid(column=1, row=7)
agechoosen.current()
window.mainloop()
我认为问题在下面提到的行中,但我不确定。请帮忙
agechoosen['values'] = (tempAge)
salchoosen['values'] = (Salary)
根据上述意见中@acw1668的建议。我添加了n=tk.StringVar()和m=tk.StringVar(),结果成功了。 这是最后的代码
相关问题 更多 >
编程相关推荐