ua1zcl
asked on
Recordset by SQL in MFC, from record to record ...
The question about MFC C++ or MS Windows C++ for
Database managment.
For example: You have database ( MDB or SQL )
1) How to open recordset by SQL in MFC C++?
2) If recordset open, then how to go from record to record to update recordset?
3) How to delete, insert, select recordset in C++.
Please propose a web link to examle or something else.
Alex.
Database managment.
For example: You have database ( MDB or SQL )
1) How to open recordset by SQL in MFC C++?
2) If recordset open, then how to go from record to record to update recordset?
3) How to delete, insert, select recordset in C++.
Please propose a web link to examle or something else.
Alex.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Mupchu777 and James(jtwine), thank to both. I not accept
any answer until few days let me see for all i got.
Excuse me, but i must rejcet Mupchu777 answer for some time, that is e-e recomendations.
any answer until few days let me see for all i got.
Excuse me, but i must rejcet Mupchu777 answer for some time, that is e-e recomendations.
ASKER
Mupchu777 and James(jtwine), thank to both. I not accept
any answer until few days let me see for all i got.
Excuse me, but i must rejcet Mupchu777 answer for some time, that is e-e recomendations.
any answer until few days let me see for all i got.
Excuse me, but i must rejcet Mupchu777 answer for some time, that is e-e recomendations.
ua1zcl,
I agree with jtwine that CRecordset/CDatabase is the easiest way to get started. Would you like a step-by-step instruction guide?
-- Dan
I agree with jtwine that CRecordset/CDatabase is the easiest way to get started. Would you like a step-by-step instruction guide?
-- Dan
ASKER
I accept mupchu777 answer. Thanks a lot.
I can't find a button to press to accept an answer
for now.
I can't find a button to press to accept an answer
for now.
I think if I make another comment you can accept that as an answer. You can't accept my old answer as you have already rejected it.
I would also clarify that yes CDatabase and CRecordset are options as well. It is syntaticly similar to CDAODatabase and CDAORecordset. Personally I would avoid the MFC classes and use ADO (through the import command), but that is just my preference. The only thing I could really argue is the programming model of ADO coupled with a fairly tight wrapper with little overhead.
I would also clarify that yes CDatabase and CRecordset are options as well. It is syntaticly similar to CDAODatabase and CDAORecordset. Personally I would avoid the MFC classes and use ADO (through the import command), but that is just my preference. The only thing I could really argue is the programming model of ADO coupled with a fairly tight wrapper with little overhead.
ASKER
I am new in data base programming and can not
anythig argue against. So, thank you , hope meet you again here.
Alex.
anythig argue against. So, thank you , hope meet you again here.
Alex.
I think you forgot this question. I will ask Community Support to close it unless you finalize it within 7 days. Unless there is objection or further activity, I will suggest to accept "mupchu777" comment(s) as an answer.
If you think your question was not answered at all, you can post a request in Community support (please include this link) to refund your points.
The link to the Community Support area is: https://www.experts-exchange.com/commspt
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
======
Werner
If you think your question was not answered at all, you can post a request in Community support (please include this link) to refund your points.
The link to the Community Support area is: https://www.experts-exchange.com/commspt
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
======
Werner
Per recommendation, force-accepted by
Netminder
Community Support Moderator
Experts Exchange
Netminder
Community Support Moderator
Experts Exchange
That way, you can use ClassWizard's support for creating the DB classes for you and binding the columns to data members. The CRecordset contains methods to easily Insert, Edit, and Delete rows in a database. Not the fastest at runtime, but pretty quick to implement.
-=- James.