Entering variable in db

[subratatamal]

"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]

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;
...

...
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;
...

To copy to clipboard, switch view to plain text mode 

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;

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;

To copy to clipboard, switch view to plain text mode