vb.net database question


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: vb.net database question

  1. #1
    dc Guest

    vb.net database question


    Im lost. I have vb.net standard and I need to know if I have what I need
    to create a standalone database for a small organization. Im not sure what
    ADO.net is, if it is what Im talking about or even if it comes with the standard
    addition. However, can I create a database for this group or do I have to
    have the professional edition?

    dc

  2. #2
    Michael Culley Guest

    Re: vb.net database question

    ADO.net it what you need. Its objects are in System.Data,SqlClient (for sql
    server) and System.Data.OleDB (for everything else). Unfortunately there is
    a little too much to explain in a message. Can you give it atry and come
    back with a more specific question. Here is a starts.

    Connection work just like the old ADO, to create one is something like this

    Dim cnxTemp as new sqlclient.sqlconnection(put connectionString here)

    --
    Michael Culley
    www.vbdotcom.com



    "dc" <fffreddyyy@hotmail.com> wrote in message news:3cc39f14$1@10.1.10.29...
    >
    > Im lost. I have vb.net standard and I need to know if I have what I need
    > to create a standalone database for a small organization. Im not sure

    what
    > ADO.net is, if it is what Im talking about or even if it comes with the

    standard
    > addition. However, can I create a database for this group or do I have to
    > have the professional edition?
    >
    > dc




  3. #3
    Paul Mc Guest

    Re: vb.net database question


    G'day.

    >I have vb.net standard and I need to know if I have what I need
    >to create a standalone database for a small organization.


    VB.Net is a tool for creating exe/dll applications - ie front/end (basically).
    To create a database, you need some kind of data storage medium - ie a database
    management system. Two examples are Access, and SQL Server. Depending how
    many users you need, you should be able to use the "Personal" edition of
    SQL Server (MSDE), (see http://msdn.microsoft.com/library/de...nAboutMSDE.asp
    and beware of line wrap).

    MSDE may be a bit of a pain on its own, as it comes with no gui stuff - but
    maybe you could use the VS.Net IDE...


    >Im not sure what
    >ADO.net is, if it is what Im talking about or even if it comes with the

    standard
    >addition.


    AFAIK it does come with Standard.
    ADO.Net is just a set of components that allow you to connect to various
    data storage mediums and just generally work with the data. It is the .Net
    evolution of ADO, DAO etc, if you are familiar with those...

    HTH,
    Cheers,
    Paul

  4. #4
    dc Guest

    Re: vb.net database question


    I do have access 2000 and am good at it so I have a base storage system with
    that. What I need to know is this....

    With vb.net Standard edition do I have what I need to use access either over
    a server or standalone on a desktop. What I mean by standalone; can one
    computer have my created program in vb.net and access and maintain a database?

    next question, do I heve to use access? can I make up a small database just
    using vb.net so that the end user doesnt need access. i.e. create the database,
    records, querry, etc. just using vb.net.

    dc

  5. #5
    Scott Hutchinson Guest

    Re: vb.net database question

    "dc" <fffreddyyy@hotmail.com> wrote in message news:3cc42287$1@10.1.10.29...
    >
    > I do have access 2000 and am good at it so I have a base storage system

    with
    > that. What I need to know is this....
    >
    > With vb.net Standard edition do I have what I need to use access either

    over
    > a server or standalone on a desktop. What I mean by standalone; can one
    > computer have my created program in vb.net and access and maintain a

    database?

    I'm pretty sure you have what you need. To verify this, create a new Windows
    Application in VB .NET. Look in Solution Explorer to confirm that there is a
    reference to the System.Data namespace. If not, then add it. Then look in
    the Object Browser under "System.Data". If there is a namespace called
    "System.Data.OleDb", then you have what you need to use an Access database
    (assuming that you also have the Jet OLE DB provider installed, but that's
    already installed on most Windows machines these days).

    >
    > next question, do I heve to use access? can I make up a small database

    just
    > using vb.net so that the end user doesnt need access. i.e. create the

    database,
    > records, querry, etc. just using vb.net.


    This is possible with one caviat. The only part that's not quite built into
    VB .NET is creating a new Access database. To do that you would need to
    reference either ADOX or DAO from the COM tab of the "Add Reference" dialog
    in VB .NET. Or you could create an empty template database in Access, then
    use VB .NET to fill it with data.

    >
    > dc


    Scott Hutchinson
    s.c.o.t.t.h.u.t.c.h.i.n.s.o.n@usa.net




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center