Important: Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct
Pyqt5: Load sqlite3 database to QListWidget
DouglinhasZN last edited by DouglinhasZN
I am trying to load a column from my sqlite3 table database into my QListWidget.
Then once the user selects an item from the list, the LineEdits beneath the list will auto populate with information from the database that's linked with the item in the column selected in the list.
Could anyone guide me in the right direction?
Edit: I managed to display the content using:
conn = sqlite3.connect('Main_Database.db') curser= conn.cursor() curser.execute("SELECT Name , Type FROM Findings") hu= curser.fetchall() self.FindingsListWidget_Window.clear() for i in range(len(hu)): item= QtWidgets.QListWidgetItem(hu[i]) self.FindingsListWidget_Window.addItem(item)
I just need it to send whatever item it highlights in the Qlistwidget to the line edits field beneath
DouglinhasZN last edited by
This post is deleted!
Use the currentItemChanged signal and populate the line edit in a slot connected to that signal.
Out of curiosity, did you saw that there's the QtSql module ?