Basic Database Questions

[Miro]

Ok im a newbie to VB, and am having some trouble reading msdn help / or how
it all links together. My books are either
missing a step / or assume everything is set up correctly.

I know about tables and keys but i just cant seem to find a "starting point"
in VB.net.

1. Where do I go create a db if i only installed vb.net ? / What do I use

2. Or is there a good tutorial somewhere of what to do. I have 3 books and
they all "assume" i have an mdb file
or something. - Stupid books. - I want to create my own tables / dataset

My basic goal is to create a form that creates a db file with multiple
tables and i have relations. Where I can add / deleete / ...
records into the database.

So i really need ot know what needs to be configured for vb.net so I can
create a db with tables and then once i create an
install for a new computer this will work as well.

--- May or may not be linked to question one.
3. What database connection do you use? Does the SQL server come with
vb.net or must it be purchased ?
Did I install something wrong and i dont have an SQL server - or i didnt
configure something?


Thank You

Miro

 

[Chris]

Ok im a newbie to VB, and am having some trouble reading msdn help / or how
it all links together. My books are either
missing a step / or assume everything is set up correctly.

I know about tables and keys but i just cant seem to find a "starting point"
in VB.net.

1. Where do I go create a db if i only installed vb.net ? / What do I use

2. Or is there a good tutorial somewhere of what to do. I have 3 books and
they all "assume" i have an mdb file
or something. - Stupid books. - I want to create my own tables / dataset

My basic goal is to create a form that creates a db file with multiple
tables and i have relations. Where I can add / deleete / ...
records into the database.

So i really need ot know what needs to be configured for vb.net so I can
create a db with tables and then once i create an
install for a new computer this will work as well.

--- May or may not be linked to question one.
3. What database connection do you use? Does the SQL server come with
vb.net or must it be purchased ?
Did I install something wrong and i dont have an SQL server - or i didnt
configure something?


Thank You

Miro

Couple choices...

1. Create the database in memory using a dataset.
2. Use a microsoft access database.
3. Install MSDE, the free version of SQL server.

Chris

 

[Cor Ligthert [MVP]]

Miro,

We don't know what version you use from VB.Net which makes answering
difficult.

Because some of your questions I assume it is a 2003 version (although your
books are in my opinion about that or just revised ones).

To make a MDB file you can use this.
http://www.vb-tips.com/default.aspx?ID=e76b8450-4c8a-4662-8f41-d6dda3c888c8

For the rest try to use the website MSDN, although it is terrible to search
and find something on that is the information mostly excelent.

For your basic approach you can have a look at this as you have a 2005
version. Be aware that this is very generic and probably unusable in a real
situation. It gives however a nice starting view.

http://www.vb-tips.com/default.aspx?ID=1139f14a-c236-4ad7-8882-b1ed16424252

SQL server for production has to be purchased, although there is a kind of
starters SQL server the SQL express, which is free.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp

I hope this helps so far,

Cor

 

[Miro]

I have 2003

I will look at the examples you gave me.

Thanks

Miro