QlineEdit + Sql Problem

[anouar2002]

Hello,
I want create a QlineEdit which shows values from SQL Server Database.
I try to do it in this way but no result (empty QlineEdit area) :

QString sQuery = QString("SELECT  Matricule FROM Projet.dbo.Produit WHERE Nom='%1' ").arg(ui->comboBox->currentText());
 
           QSqlQuery query;
           query.exec( sQuery );
 
            QString name = query.value(0).toString();
 
             ui->lineEdit_3->setText(name);
 
}

QString sQuery = QString("SELECT  Matricule FROM Projet.dbo.Produit WHERE Nom='%1' ").arg(ui->comboBox->currentText());

           QSqlQuery query;
           query.exec( sQuery );

            QString name = query.value(0).toString();
          
             ui->lineEdit_3->setText(name);

}

To copy to clipboard, switch view to plain text mode 

Any Suggestions ?? Thanks previsiouly