[PyQt] [Solved]Help displaying SQLite Database

[Axel_Erfurt]

Here's the table (called items) that was created:

Ok, that works for me after changing self.tableWidget to self.InventoryDisplay in loaddata

self.tableWidget was never defined

    def loaddata(self):
        connection = sqlite3.connect("inventory.db")
        cursor = connection.cursor()
        cursor.execute('select * from items')
 
        tablerow=0
        results = cursor.fetchall()
        self.InventoryDisplay.setRowCount(40)
        for row in results:
            self.InventoryDisplay.setItem(tablerow, 0, QtWidgets.QTableWidgetItem(row[0]))
            self.InventoryDisplay.setItem(tablerow, 1, QtWidgets.QTableWidgetItem(row[1]))
            self.InventoryDisplay.setItem(tablerow, 2, QtWidgets.QTableWidgetItem(row[2]))
            tablerow+=1
        connection.close()
        #---------------------------------------------------------------------
   
        self.retranslateUi(self)
        QMetaObject.connectSlotsByName(self)