Thread: create a data base in vb.net 2008

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??

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.

can an SQL server be created using the express edition on vb.net 2008?

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.

ohk. thanks

is there a tutorial that you know of that can assist me in using that??

I would imagine that the Data Walkthroughs and Video links in my signature would help.

i was hoping you had something more visual but thats ohk thanks anyway

I'm guessing that the videos are somewhat visual and the Forms over Data series has 19 episodes.