Printable View
I want to make a program that will allow the user to enter data into a set number of fields and then the program should store this data.
However what would be the best way to save the data?
Should I save it as a txt file or should I go the whole hog and try and learn about databases and all that?
Thanks
AL
PS. I'm only a relative newbie to programming so I'm not sure about what to do.
PPS. I'm using Visual Studio 2010
To me, that depends on the data. Will you only ever need to use 1 or 2 sets of data? If so then files should be fine. If you users are going to store this data multiple times a day and want to pull up older sets of data, then a Database is best.
That is the short answer. There are many other thing that go into deciding on where to store your data. Security, deployment ease of access are just a few.
So, what are your plans with the data??
If you have a lot of data, then you need a database. LINQ to SQL makes working with databases very easy.
If it's not a lot, then you have a number of different options for writing to files, or you can look into Serialization for saving data, user preferences, etc.
Another way you'd want to look at it is if the data you are trying to save needs to be accessed on a local machine or by another machine. If it's being used locally and there's not too much data, you should use files, probably being XML and INI (personal preferences.) If the data is being exchanged, edited on a website or if there is a server involved, you might want to use a database. (MySQL is the easiest, NHibernate I hear is one of the best yet hardest)
Or you could always look at it from an organization standpoint. SQL is very easy to be organized if you know what you're doing, same with XML and INI again, if you know how to read the files. It all really comes down to preference and what sort of application needs to access data and how.