View data from database in Listwidget with pyqt5

-1

I try to display the data from DB in List Widget, but I get this message

C:\Users\msejj\PycharmProjects\pythonProject1\venv\Scripts\python.exe "C:/Users/msejj/OneDrive/Desktop/DesktopAnwendung Pr.4/userinterface/DatenÜbertragung.py"

Process finished with exit code -1073740791 (0xC0000409)

User Interface works, but no data transfer when i click on Button Start

import sys
import numpy as np
from Interface_Listwidget import Ui_MessungZeiger
from PyQt5 import *
import sqlite3 as sql

class Dataubertragung(Ui_MessungZeiger):
    def __init__(self, MessungZeiger):
        self.setupUi(MessungZeiger)
        self.pushButton.clicked.connect(self.Click_Start)

    def Click_Start(self):
        MAX = 0  # für Anzahl der Messungen
        db = sql.connect('messwerte.db')
        cursor = db.cursor()
        #cursor.execute('DROP TABLE IF EXISTS MESSUNGEN')
        #db.commit()
        cursor.excute('''SELECT Temp From Messwerte ''')
        row = cursor.fetchone()
        if row != None:
            MAX = row[0]
        else:
            sys.exit(0)

        array = np.zeros((MAX,2), np.int16)
        cnt = 0

        cursor.execute(''' SELECT Temp from Messwerte''')
        all_rows = cursor.fetchall()
        for row in all_row:
            data ='{:3d}:'.format(('row[0]'))
            self.listWidget.addItems(s)
            array[cnt,0] = row[1]
            cnt+=1

        db.close()


if __name__ == "__main__":
    import sys
    app = QtWidgets.QApplication(sys.argv)
    MessungZeiger = QtWidgets.QDialog()
    ui = Dataubertragung(MessungZeiger)
    MessungZeiger.show()
    sys.exit(app.exec_())
python
pyqt5
qlistwidget
asked on Stack Overflow May 16, 2021 by MS_EJJ • edited May 16, 2021 by eyllanesc

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0