Hi!
Photo are stored in a SQLite Database (from other application). Now I load data from database and want to load image in my label.
When I debug it, QByteArray is ok. But QPixmap is invalid. How can I fix it?
Thanks
.h file
#ifndef MAINWINDOW_H
#define MAINWINDOW_H
#include <QMainWindow>
#include <QSqlDatabase>
#include <QSqlQuery>
namespace Ui {
class MainWindow;
}
{
Q_OBJECT
public:
explicit MainWindow
(QWidget *parent
= 0);
~MainWindow();
private slots:
void on_pushButton_clicked();
private:
Ui::MainWindow *ui;
};
#endif // MAINWINDOW_H
#ifndef MAINWINDOW_H
#define MAINWINDOW_H
#include <QMainWindow>
#include <QSqlDatabase>
#include <QSqlQuery>
namespace Ui {
class MainWindow;
}
class MainWindow : public QMainWindow
{
Q_OBJECT
public:
explicit MainWindow(QWidget *parent = 0);
~MainWindow();
QSqlDatabase myDb;
QSqlQuery *query;
private slots:
void on_pushButton_clicked();
private:
Ui::MainWindow *ui;
};
#endif // MAINWINDOW_H
To copy to clipboard, switch view to plain text mode
.cpp file
#include "mainwindow.h"
#include "ui_mainwindow.h"
#include <QDebug>
#include <QPixmap>
#include <QSqlError>
#include <QBuffer>
MainWindow
::MainWindow(QWidget *parent
) : ui(new Ui::MainWindow)
{
ui->setupUi(this);
}
MainWindow::~MainWindow()
{
delete ui;
}
void MainWindow::on_pushButton_clicked()
{
myDb.setDatabaseName("D:/ArtistPhoto.db3");
if (!myDb.open()) {
qDebug() << " not open";
}
else {
qDebug() << " opened";
query
= new QSqlQuery ("SELECT Data FROM Artist WHERE NOT data IS NULL",myDb
);
if(query->first()) {
QByteArray outByteArray
= query
->value
("Data").
toByteArray();
outPixmap.loadFromData( outByteArray );
if(outPixmap.loadFromData(outByteArray,"PNG")) ui->label->setPixmap(outPixmap);
}
myDb.close();
}
}
#include "mainwindow.h"
#include "ui_mainwindow.h"
#include <QDebug>
#include <QPixmap>
#include <QSqlError>
#include <QBuffer>
MainWindow::MainWindow(QWidget *parent) :
QMainWindow(parent),
ui(new Ui::MainWindow)
{
ui->setupUi(this);
}
MainWindow::~MainWindow()
{
delete ui;
}
void MainWindow::on_pushButton_clicked()
{
myDb = QSqlDatabase::addDatabase("QSQLITE","myconnection");
myDb.setDatabaseName("D:/ArtistPhoto.db3");
if (!myDb.open()) {
qDebug() << " not open";
}
else {
qDebug() << " opened";
query = new QSqlQuery ("SELECT Data FROM Artist WHERE NOT data IS NULL",myDb);
if(query->first()) {
QByteArray outByteArray = query->value("Data").toByteArray();
QPixmap outPixmap = QPixmap();
outPixmap.loadFromData( outByteArray );
if(outPixmap.loadFromData(outByteArray,"PNG")) ui->label->setPixmap(outPixmap);
}
myDb.close();
}
}
To copy to clipboard, switch view to plain text mode
Project source code and database file
http://bit.ly/2F1FNmd
Bookmarks