SQL tutorials
SQL tutorials
SQL tutorials
SQL tutorials
SQL tutorials
SQL tutorials SQL tutorials SQL tutorials SQL tutorials SQL tutorials SQL tutorials SQL tutorials SQL tutorials
SQL tutorials SQL tutorials
SQL tutorials
Go Back  Xtreme Visual Basic Talk > > > SQL tutorials


Reply
 
Thread Tools Display Modes
  #1  
Old 02-01-2012, 04:58 PM
bigmonmulgrew bigmonmulgrew is offline
Regular
 
Join Date: Feb 2008
Posts: 73
Default SQL tutorials


Hi guys
I've been googling to find a guide on how to access a database with visual studio.
I cant find anything complete or up to date.

I should point out that I dont have a great deal of experience with SQL.

I'm not really 100% sure where to start. Most of the guides I've found tend to assume your accessing an existing SQL database and I need to set one up from scratch. I'm not sure if I'm even setting SQL server up correctly.

Could someone point me in the right direction on where to get started. A good, up to date tutorial would be great.

For my purposes the SQL database will only be written to from the local machine but there will also be another machine writing to this database.

I'm currently using Visual basic Express 2010 and SQL Server Express 2008 R2, mostly because they are the most recent when I googled it.

All the machines I'm working on are running Windows 7 64bit.
__________________
Currently Running VB Express 2010, running on Windows 7 home premium x64
System: Gigabyte GA-MA790FX-DS5, Athlon X2 5600+, Corsair 2GB matched pair 800mhz 4-4-4-12 (epp), XFX Geforce 8600GTS 256MB, Raptor 74GB SATA, Corsair HX 630W
My Blog:http://foreverythingit.co.uk/blog
Reply With Quote
  #2  
Old 02-01-2012, 09:33 PM
surfR2911 surfR2911 is offline
Contributor
 
Join Date: Oct 2009
Posts: 719
Default VB.Net 2010 Express and SQL Server Express

You couldn't find anything..really?

Here's what I found in about 5 minutes googling (preety basic but should get you started:
An MSDN overview - DAC versus non-DAC
http://msdn.microsoft.com/en-us/library/ff678491.aspx
Programming an SQL "Inner Join" using VB.Net (includes link to earlier/simpler tutorial as well):
http://visualbasic.about.com/od/usin.../begdbapp2.htm
An extremely simple article on "Debugging Databases with Visual Studio and SQL Server"
http://visualbasic.about.com/od/usin.../begdbapp4.htm
Manage SQL Server Projects With Visual Studio (with a liberal sprinkling of screenshots):
http://www.visualstudiotutor.com/201...visual-studio/
VISUAL BASIC 2010 EXPRESS & SQL SERVER 2008 EXPRESS -Two great tools that go great together (screenshots and code):
http://michikami.blogspot.com/2011/0...ql-server.html

Quote:
For my purposes the SQL database will only be written to from the local machine but there will also be another machine writing to this database.
Usually I've only seen using a local host (local hard drive) as a development configuration then later deployed o either a lan server or a web server, so you many not find many tutorials oriented toward this configuration.
The only thing I found was this:
"I am trying connect to a SQL Server database i have created using Visual Basic. Both reside on my local machine":
http://www.dreamincode.net/forums/to...m-vb-2010-exp/

The Transact-SQL used by Microsoft Server 2008 is such a huge subject. There are entire books written about it. I think I'll just give you a starting point in the MSDN and let you explore from there (feel free to ask more specific questions later..as you get further into it..)
http://msdn.microsoft.com/en-us/library/bb510741.aspx
Reply With Quote
  #3  
Old 02-02-2012, 06:53 AM
bigmonmulgrew bigmonmulgrew is offline
Regular
 
Join Date: Feb 2008
Posts: 73
Default

Thanks for all that, may take me quite a while to go through.
I think part of my issue is that I wasnt exactly sure where to begin.
Googles much easier to use when you know what your looking for.
__________________
Currently Running VB Express 2010, running on Windows 7 home premium x64
System: Gigabyte GA-MA790FX-DS5, Athlon X2 5600+, Corsair 2GB matched pair 800mhz 4-4-4-12 (epp), XFX Geforce 8600GTS 256MB, Raptor 74GB SATA, Corsair HX 630W
My Blog:http://foreverythingit.co.uk/blog
Reply With Quote
  #4  
Old 02-23-2012, 09:03 PM
CharlieMay's Avatar
CharlieMay CharlieMay is offline
Regular
 
Join Date: Sep 2009
Location: Indiana
Posts: 89
Default

For the beginner (and I'm not taking anything away from you when I say that) I really think the the Forms Over Data Videos that Beth Massi has are great for learning data access. Of course she does a lot with the strongly typed data objects but I feel this is a good learning step for people that are not real strong in SQL. Drag and drop a control and with minimal code you're storing, updating and deleting information which is the basics of a database anyway.
__________________
I thought I knew what I was doing...
...And then I turned on Option Strict
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
SQL tutorials
SQL tutorials
SQL tutorials SQL tutorials
SQL tutorials
SQL tutorials
SQL tutorials SQL tutorials SQL tutorials SQL tutorials SQL tutorials SQL tutorials SQL tutorials
SQL tutorials
SQL tutorials
 
SQL tutorials
SQL tutorials
 
-->