I am trying to create a database of contacts for a program that would run locally (kinda like ms outlook) for easy searching and data manipulation. I am not sure however, how to go about doing so. I was thinking of creating a mySQL database, but I am not sure if it was meant for local programs (i have never worked with databases before)...any tips or hints would be very helpful. Thank you.
Well, you could define a record type for your data element (which in your case is a contact), and then use file i/o to retrieve/store data from/to a file on your hard drive.
Thank you very much guys, after reading you replies it got me thinking...does my program really need a database? I mean, I'm going to want to store and load around 1000 contacts every time the program starts.
SQL Server Compact seems very appealing but I'm not sure what the fastest way to deal with around 1000 instances of a class is.
So my main question is, what would be more efficient for 1000 class instances; a database like SQL or even Access, or should I just store everything in a txt file.