Basic Database Questions

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Miro
    #1

    Basic Database Questions

    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




    Tags: None
    • Chris
      #2
      Re: Basic Database Questions

      Miro wrote:[color=blue]
      > 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
      >
      >
      >
      >[/color]

      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

        Comment

        • Cor Ligthert [MVP]
          #3
          Re: Basic Database Questions

          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/de...seoverview.asp

          I hope this helps so far,

          Cor



          "Miro" <mironagy@golde n.net> schreef in bericht
          news:eJ6EozxcGH A.2188@TK2MSFTN GP05.phx.gbl...[color=blue]
          > 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
          >
          >
          >
          >[/color]


            Comment

            • Miro
              #4
              Re: Basic Database Questions

              I have 2003

              I will look at the examples you gave me.

              Thanks

              Miro

              "Cor Ligthert [MVP]" <notmyfirstname @planet.nl> wrote in message
              news:u3KFwLycGH A.3952@TK2MSFTN GP04.phx.gbl...[color=blue]
              > 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?...1-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?...2-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/de...seoverview.asp
              >
              > I hope this helps so far,
              >
              > Cor
              >
              >
              >
              > "Miro" <mironagy@golde n.net> schreef in bericht
              > news:eJ6EozxcGH A.2188@TK2MSFTN GP05.phx.gbl...[color=green]
              >> 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
              >>
              >>
              >>
              >>[/color]
              >
              >[/color]


                Comment

                Previous template Next
                Working...