How to get value from a query statement ?

[hohoanganh205]

Thanks you very much, I done.

QSqlQuery q("select count(MaDaiLy) as SoDaiLyTrongQuan from DaiLy, Quan where DaiLy.Quan_TenQuan = Quan.TenQuan and Quan.TenQuan = '" + ui.cbTenQuan->currentText() + "'");
		QSqlRecord rec = q.record();
		int nameCol = rec.indexOf("SoDaiLyTrongQuan"); // index of the field "name"
		q.next();
		int SoDLHienCoTrongQuan = q.value(nameCol).toInt();

QSqlQuery q("select count(MaDaiLy) as SoDaiLyTrongQuan from DaiLy, Quan where DaiLy.Quan_TenQuan = Quan.TenQuan and Quan.TenQuan = '" + ui.cbTenQuan->currentText() + "'");
		QSqlRecord rec = q.record();
		int nameCol = rec.indexOf("SoDaiLyTrongQuan"); // index of the field "name"
		q.next();
		int SoDLHienCoTrongQuan = q.value(nameCol).toInt();

To copy to clipboard, switch view to plain text mode 

the result is return: 2

[Lykurg]

Hi, since you only query one "field" the index is 0. Thus you can simplify your code:

QSqlQuery q("select count(MaDaiLy) from DaiLy, Quan where DaiLy.Quan_TenQuan = Quan.TenQuan and Quan.TenQuan = '" + ui.cbTenQuan->currentText() + "'");
q.next();
int SoDLHienCoTrongQuan = q.value(0).toInt();

QSqlQuery q("select count(MaDaiLy) from DaiLy, Quan where DaiLy.Quan_TenQuan = Quan.TenQuan and Quan.TenQuan = '" + ui.cbTenQuan->currentText() + "'");
q.next();
int SoDLHienCoTrongQuan = q.value(0).toInt();

To copy to clipboard, switch view to plain text mode 

Further have a look at QSqlQuery::bindValue().