[PyQt] [Solved]Help displaying SQLite Database

[Axel_Erfurt]

try this

    def loaddata(self):
        connection = sqlite3.connect("inventory.db")
        cursor = connection.cursor()
        cursor.execute('select * from items')
        row = 0
        self.InventoryDisplay.setRowCount(40)
        while True:
            form = cursor.fetchone()
            if form == None:
                break
            for column, item in enumerate(form):
                self.InventoryDisplay.setItem(row, column, QTableWidgetItem(str(item)))
                print(str(item))
            row += 1
        connection.close()
        #---------------------------------------------------------------------
        
        self.retranslateUi(self)
        QMetaObject.connectSlotsByName(self)