@SGaist I did it this way for reading return params:

Query.nextResult(); // after reading table values //Get Return Parameter for (int i=0; i<CountReturnParam; i++) { qDebug() << QString("Returnparam %1 = %2") .arg(i).arg(Query.boundValue(i).toString()); }

@M4RZB4Ni said in Create Login Form (SqlServer 2014):

pass(show from db)

I just noticed this. if your DB knows what the password is it is a threat not only to your DB security but for each individual user. You can get sued for some real money! (the idea is that if your DB gets hacked and password table stolen the attackers will have both username and password in plain text and, if passwords are recycled by your users, they will try them on paypall or amazon and steal money off them).

Use a hash and salt algorithm (SHA3 512 recommended).

An "entertaining" explanation can be found here: https://www.youtube.com/watch?v=8ZtInClXe1Q

@M4RZB4Ni
yes, the big question is if they are on same lan/network. :)

If you have SQL server why not just create a stored procedure in the server and call it in C++?! It's the best option under all circumstances.

If you can't use that then use a select then use something like:

bool alreadyExist = false; { QSqlQuery query; query.prepare("select * from MyTable where rowID=:rowID"); query.bindValue(":rowID",rowID); if(!query.exec()){ // select failed } alreadyExist = query.next(); } if(alreadyExist){ // update } else{ //insert }

hi
You can use
http://doc.qt.io/qt-5/qdatawidgetmapper.html

to insert data to label. It can not be directly tied to a model.

@hskoglund
Thank You So much man
My Problem Solved!

You can use QSqlQuery to run the select statements and loop the resultset with next() like in VRonin´s example. If you comma seperate the columns like in VRonin´s example you can open this file in excel.

One more option, if your on windows is to use ODBC Excel Driver to generate the Excel file. With this you can use QSqlQuery to create tables and insert rows.

Well, follow the documentation starting here. You'll find the relevant topics on how to connect to a database, run queries, use models etc.