ref = self.ref_lineEdit.text()

connection = sqlite3.connect("db.db")
result = connection.cursor()
result = connection.execute("SELECT * FROM order WHERE ref = '"+ref+"'")
data = result.fetchall()
connection.close()

I want to get the information from database table to display all rows on a qttable. Can some help me get this information to display on table. like a list

thank you