Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with sqlite3.connect('database.db') as db:
- cursor=db.cursor()
- cursor.execute('select* from Item Order BY Name ASC')
- title = [cn[0] for cn in cursor.description]
- rows = [cn[0] for cn in cursor.description]
- cur=cursor.fetchall()
- layout = QtGui.QGridLayout()
- self.test = QtGui.QLineEdit('test') #This is just a test for printing text into the table and works fine.
- self.table = QtGui.QTableWidget()
- for rows in cur:
- print(rows[1]) #This is just a test to see if the data could be printed into python shell, which worked.
- #self.test2 = QtGui.QLineEdit(cur)
- #self.table.setVerticalHeaderLabels(rows)
- self.table.setRowCount(3)
- self.table.setColumnCount(5)
- self.table.setHorizontalHeaderLabels(title) #This code works fine, the column headers are the ones from my database.
- #self.table.setVerticalHeaderItem(1,row)
- layout.addWidget(self.table, 0, 0)
- self.table.setItem(0, 0, QtGui.QTableWidgetItem(self.test.text()))
- #self.table.setItem(1, 0, QtGui.QTableWidgetItem(self.test2.text()))
- self.setLayout(layout)
- cur=cursor.fetchall()
- for i,row in enumerate(cur):
- for j,val in enumerate(row):
- table.setItem(i, j, QtGui.QTableWidgetItem(str(val)))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement