+ Post New Thread
Results 1 to 7 of 7
Coding Thread, Create SQL Database and Tables from VB.net 2010 in Coding and Web Development; Hi all, I'm new to VB.Net coming from VB6 I need to create an SQL database and it's tables from ...
  1. #1
    Grazza's Avatar
    Join Date
    Jun 2010
    Location
    Walsall
    Posts
    34
    Thank Post
    2
    Thanked 4 Times in 1 Post
    Rep Power
    9

    Create SQL Database and Tables from VB.net 2010

    Hi all,

    I'm new to VB.Net coming from VB6

    I need to create an SQL database and it's tables from with in VB.Net

    Does anybody have any code for this.

    Regards

    Graham

  2. #2

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,991
    Thank Post
    114
    Thanked 507 Times in 342 Posts
    Blog Entries
    2
    Rep Power
    286
    I used Linq to SQL for a couple of projects a while back. It doesn't seem a popular method, though, but I quite liked the way it worked as it blended SQL with native code.
    Introduction to LINQ
    http://msdn.microsoft.com/en-us/libr...vs.100%29.aspx


    ADO is the more usual way.
    How Do I Use the Connection Object in ADO?
    Last edited by jinnantonnixx; 9th December 2013 at 03:59 PM.

  3. #3
    Grazza's Avatar
    Join Date
    Jun 2010
    Location
    Walsall
    Posts
    34
    Thank Post
    2
    Thanked 4 Times in 1 Post
    Rep Power
    9
    Thanks for that, I've had a a little read up about Linq and I'm going to get a few books on the subject.

    I've ordered a few books on ADO.Net and VB.Net 2010 (5 in total) only cost me £15! Used books of course, but when you can get a £50 Book for 1p + p&p off Amazon, well you can't go wrong can you!

    Thanks again
    Graham

  4. #4

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,877
    Thank Post
    518
    Thanked 2,486 Times in 1,928 Posts
    Blog Entries
    24
    Rep Power
    838
    Linq is about a bazillion times easier and quicker to use than ADO in my experience. I switched my cashless catering system from ADO to Linq a couple of years ago. It knocked a huge chunk of code off my project size too. Definitely something to look at.

  5. #5

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,991
    Thank Post
    114
    Thanked 507 Times in 342 Posts
    Blog Entries
    2
    Rep Power
    286

  6. #6

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,991
    Thank Post
    114
    Thanked 507 Times in 342 Posts
    Blog Entries
    2
    Rep Power
    286
    If you've used the object builder in Visual Studio (i.e. dragged in a DB from SQL Explorer), and the DB changes structure (*cough*) you'll have to edit the table definitions in the auto-generated code. That's the only catch I've found.

  7. #7

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,877
    Thank Post
    518
    Thanked 2,486 Times in 1,928 Posts
    Blog Entries
    24
    Rep Power
    838
    Indeed. But that can be done using drag and drop pretty quickly so it doesn't take much effort in my experience.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS SQL Databases and Maintenance Plans
    By Olliesaurus in forum MIS Systems
    Replies: 12
    Last Post: 15th November 2013, 03:42 PM
  2. vb.net 2010 System Tray Icon and Popup Menu
    By mac_shinobi in forum Coding
    Replies: 19
    Last Post: 11th April 2011, 06:39 PM
  3. VB .Net 2010 Remote Registry Access
    By Duke5A in forum Coding
    Replies: 2
    Last Post: 5th April 2011, 08:05 AM
  4. vb.net and database security
    By Hightower in forum Coding
    Replies: 5
    Last Post: 6th May 2010, 11:01 AM
  5. Replies: 2
    Last Post: 28th March 2006, 12:15 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •