def __init__(self): QtGui.QDialog.__init__(self) self.modify = Ui_modify_teacher() self.modify.setupUi(self) self.Admin_id = 0 self.Teacher_id = 0 self.conn() self.modify.sel_teach = QSqlRelationalTableModel(db=self.db) self.modify.sel_teach.setTable("Teacher") if not self.conn(): QtGui.QMessageBox.warning(self, 'Error', 'database contecting error') self.teach_query = QSqlQuery() self.teach_query.exec_("Select Teacher_name FROM Teacher") while self.teach_query.next(): record = self.teach_query.record() self.name = str(record.value(0)) self.modify.selectTeacherComboBox.addItem(self.name) self.modify.Select_teacher_btn.clicked.connect(self.fillForm) self.modify.Submit_btn.clicked.connect(self.submitUpdates)