I'm partway through a class on C++, and, naturally, we have a project due for the term. I'm a DJ by trade, and have an extensive record collection. The project I've chosen is to build and maintain a program that can keep track of my collection (based from the professors example idea of a CD collection).
I'm doing fine with the original interface, menu, classes, etc. The problem I'm having right now is, where do I store the data I'm considering using an Access Database (since a) I have Access 2003, and b) I don't really want to do anything too complicated since this is just a school project).
I don't know, however, how to write code to interact with the database. I've used SQL before when doing Cold Fusion programming, but not for anything like this. I know how to set up the database in the first place, but I just don't know how to save/retrieve the data.
Any help
Taking a C++ class...
Sabre D
Learn about the CDatabase and CRecordset classes. They will get you what you want. Specifically, take a look at CDatabase::OpenEx().
Stéphane Beauchemin
Aleksey Nagoga.
Thanks for the heads up :)
I think I'll take your advice and get a bit more down on this. Since I've yet to see anything about databases in any of the books I own on C++, I thought it might be past the scope of a newbie like myself. I'm gonna drop the "search" part of my project, and just have it write to a file, then list the whole collection.
Which, since this is just a project, I won't exactly need to list all 3,000+ records ;)
I do have a bit of knowledge in programming in general, with some Java, C#, CFML, XML, SQL, XHTML, and a few others under my belt. Just don't have this part of it down yet.
SQLobSERVER.com
I suggest you spend some more time reading up on C++ before diving into the database access. Once you've got a hang of the language, and programming in general, getting the data store down isn't too much trouble. That being said, there are plenty of good examples at www.codeproject.com and www.codeguru.com, so you should head over there and do some searching.