CODEWITHSUNDEEP
pythonsqliteqtablewidget
darshan katari
darshan katari

Reputation: 107

How to display in Qtablewidget the data from sqlite.

Hi, I am new to python. I am trying to display data from sqlite database in Qtablewidget but getting only row count displayed in qtablewidget. Please can anyone help me to solve this issue. Below is my code...

patientTable = QtGui.QTableWidget()
rowcount = queryCurs.execute('''SELECT COUNT(*) FROM PATIENT''').fetchone()[0]
patientTable.setRowCount(rowcount)
queryCurs.execute('''SELECT * FROM PATIENT''')
for row, form in enumerate(queryCurs):
     for column, item in enumerate(form):
            patientTable.setItem(row, column, QtGui.QTableWidgetItem(str(item)))

I need both rowcount and data from database to display. How do I do that?

Upvotes: 1

Views: 3139

Answers (1)

Aleksandar
Aleksandar

Reputation: 3661

this is how I've done it:

queryCurs.execute("SELECT * FROM PATIENT")
row = 0
while True:
    form = queryCurs.fetchone()
    if form == None:
        break
    for column, item in enumerate(form):
        patientTable.setItem(row, column, QtGui.QTableWidgetItem(str(item)))
    row += 1

Please respond if this solves your problem.

Upvotes: 2

Related Questions