create a data base
- Thread starter jkhattar
- Start date
What sort of database are you trying to create? How are you trying to create it?
im trying to create a data base for a gym management program that enable to me to store and then retrieve data such as first name last name and a photo. we havnt really touched on types of data base's could u tell me which type i should use??
Last edited:
There are a multitude of options available but the most obvious choices are Access, SQL Server CE and SQL Server Express. All integrate relatively well into VS, given that they are from Microsoft too.
Access requires you to create the database in the Access application itself, before adding it to your project. Generally the requirements for accessing the database once deployed are already built into Windows, although a driver may need to be installed for Access 2007.
SQL Server CE and SQL Server Express databases can be created directly from the Add New Item dialogue, although you must have installed the one you want to use on your development system.
SQL Server CE requires you to deploy a few extra DLLs with your application in order to access the database.
SQL Server Express requires you to install a server.
All three are free to use but the Access application itself will cost you so, if you don't already have Access, I'd suggest one of the other two.
Access requires you to create the database in the Access application itself, before adding it to your project. Generally the requirements for accessing the database once deployed are already built into Windows, although a driver may need to be installed for Access 2007.
SQL Server CE and SQL Server Express databases can be created directly from the Add New Item dialogue, although you must have installed the one you want to use on your development system.
SQL Server CE requires you to deploy a few extra DLLs with your application in order to access the database.
SQL Server Express requires you to install a server.
All three are free to use but the Access application itself will cost you so, if you don't already have Access, I'd suggest one of the other two.
Yes it can, assuming that you have installed SQL Server Express as well as VB Express. They can be downloaded from the same place or, if you downloaded the VS Express ISO file, you already have both on that image.
I would imagine that the Data Walkthroughs and Video links in my signature would help.
I'm guessing that the videos are somewhat visual and the Forms over Data series has 19 episodes.
cjard
Well-known member
- Joined
- Apr 25, 2006
- Messages
- 7,081
- Programming Experience
- 10+
i was hoping you had something more visual but thats ohk thanks anyway
In jmc sig, click the HOW DO I: VB link
Then click Forms over Data on the next page
Similar threads
- Question
