How to load fast way data from server in table using pyqt5 python | Sololearn: Learn to code for FREE!

0

How to load fast way data from server in table using pyqt5 python

i have been used QTableWidget but it is so slow load large data from database

4/3/2021 7:50:51 AM

Mahesh Kumar Gupta

19 Answers

New Answer

+1

SQL="Select * From yourtable"

+1

Join with me on Facebook

0

I use pyodbc to read data from MySQL

0

pyodbc is use for connection only

0

And when your make connection, then your are able read data.

0

By which way

0

Moment...

0

How to show data

0

How to load data fast way in QTableWidget or qtableview

0

cn = pyodbc.connect('DRIVER={MySQL ODBC 3.51 Driver};'+'User ID=youuserID;Password=yourpassword; + 'Server=192.2.0.159;Database=myworkplan;'+ 'Port=3306;String Types=Unicode') # connect

0

Change IP adress to your server IP

0

I think you can't understand what i said

0

https://facebook.com/hackermaheshkumargupta

0

Join with me in Facebook

0

cursor=cn.cursor()

0

I will ask you there

0

I am an software development so i know this

0

I am finding another thing

0

I was sending your message on Facebook. I do not know qtablewidget