时间戳

首页 > 解决方案 > Combobox Tkinter 填充数据库值

python - Combobox Tkinter 填充数据库值

问题描述

我试图用数据库值填充组合框，而我为 optionmenu 制作的组合框工作正常。但我不能让它与组合框一起工作。

    # Dictionary with options
    choices = c.execute('SELECT time date FROM data')
    tkvar.set('Select date and time') 

    lablemen= tk.Label(self, text = "Select start time", font=('helvetica', 20, 'bold'))
    lablemen.grid(row = 1 , column = 1)

    popupMenu = tk.OptionMenu(self, tkvar, *choices)
    popupMenu.config(font=('helvetica', 15, 'bold'))

    popupMenu.grid(row = 2 , column = 1)

我如何从选项菜单转到组合框？

我试过这个

  choices2 = c.execute('SELECT time date FROM data')

    cb = ttk.Combobox(self)
    cb.grid(row = 3, column = 1)

    cb['values'] = choices2

它给了我组合框的结果

标签： pythondatabasetkintercomboboxttk

解决方案

弄清楚了

    cb = ttk.Combobox(self)
    cb.grid(row = 3, column = 1)
    cblist = list()  

    for row in c.execute('SELECT time date FROM data'):

        cblist.append(row)

        cb['values'] = cblist

推荐阅读