View Full Version : Entering variable in db
subratatamal
13th December 2008, 17:19
"insert into teacher(login_id,teacher_fname,teacher_lname)value s(" + ui.txtTeacherLogin->text() + "," + ui.txtTeacherFname->text() + "," + ui.txtTeacherLname->text() + ")";
I want to add this variable(insert) into my table,but I need to pass it as string ,but i cannot able to convert them to string .any help appreciated
Subrata
spirit
13th December 2008, 17:50
I'm not sure what you mean.
...
QString insertQuery = "insert into teacher(login_id,teacher_fname,teacher_lname)value s(" + ui.txtTeacherLogin->text() + "," + ui.txtTeacherFname->text() + "," + ui.txtTeacherLname->text() + ")";
...
QSqlQuery query(insertQuery);
if (!query.exec())
return;
...
or
QSqlQuery query;
query.prepare("insert into teacher(login_id,teacher_fname,teacher_lname) value s(?, ?, ?");
query.addBindValue(ui.txtTeacherLogin->text() );
query.addBindValue(ui.txtTeacherFname->text());
query.addBindValue(ui.txtTeacherLname->text());
if (!query.exec())
return;
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.