def __init__(self): QtGui.QDialog.__init__(self) self.admin = Ui_addAdminDialog() self.admin.setupUi(self) self.idList = [] self.teach_query = QSqlQuery() self.teach_query.exec_("Select Teacher_name, Teacher_id FROM Teacher") while self.teach_query.next(): record = self.teach_query.record() self.name = str(record.value(0)) self.id = str(record.value(1)) self.idList.append(self.id) self.admin.teacherComboBox.addItem(self.name) self.admin.ok_btn.clicked.connect(self.submit) self.admin.cancel_btn.clicked.connect(self.close)