VB.NET Database Tutorial - Connecting To Microsoft SQL Server (PART 1) (Visual Basic .NET)

*** THIS CONTENT HAS BEEN UPDATED ***
SEE UPDATED SQL DATABASE TUTORIALS HERE:

SERIES PART 1:
In this beginner Visual Basic .NET tutorial, I'll show you how to establish a successful connection to a Microsoft SQL Server Database using connection strings. We'll also being using TRY / CATCH to help determine the cause of connectivity problems.

Tutorial Features:
SqlConnection - Establish a SQL Database Connection
TRY / CATCH - Capturing errors and exceptions
Functions - Test a condition and return success or failure
Classes - Design a reusable class object

PROJECT UPDATE [2/18/2016]:

[kasangoyah]

I tried this on a Visual Studio 2019 Community and SQL Server v18.5 and it worked perfectly. Thumbs up. Great tutorial.

[irfanulhaqsoofi]

I want to say a lot of thanks to you for this great tutorial. Very very helpful.

[MrJColeman]

I never thought I'd nerd out enough to enjoy doing this, but you made it so simple!

[cjones]

Your vb videos have been more helpful than many other videos, I can understand you, yo explain things very thoroughly, and your topics are spot on. I know you have updated many of your videos and look foreword to watching your other videos!

[SaaiVigneshP]

I'm currently a intermediate programmer. I skipped SQL lessons from my book because its not understandable easily. But you helped me learn SQL very easily.

[swlbarely]

Great job. You move slow enough for  me to get it without repeating the video a million times. Great teaching skills. I just got connected to my sql db via my vb.net. Thanks a bunch.

[jeofreycalica]

Posting my codes used might also help out other people .. What I really like your tutorials you sound so experts, know what you are doing and can debug codes without any hassle you know what are the inside out no matter how lengthy it is...Thumbs upp!!!

[headfracturegaming]

Thank you so much for this video series!! I spent a day and a half over a weekend trying to figure out how to do this via separate tutorials, and couldn't make a dent. You spelled it out for me perfectly, and I got it to connect to my local SQL Database!

[Aldoytoni]

Excellent set of video tutorials. Many, many thanks.

[zeyadahmed]

the best VB Teacher i glad to see VB Pro Programmer and your good series

[jayes]

thank you so much for sharing your brain wealth, Sir!!! It has been a month sifting through countless tutorials knowing there's a better way than what they're showing...

[AlesperEng]

Great video, someone in a previous comment said to use: Trusted_Connection=true works fine in place of sa/pswd. Thanks for the comments that told me to use trusted_connection=true, this works better if you are windows authenticated already logged in to your windows, they help too

[svenvd]

I see there is a lot of thanking you going on, still I want to add my appreciation for this crystal clear tutorial. This is something I can build and expand on!

[itsmejmee]

this video might be old but still saved my life. thanks a lot, man!

[todds]

Love your tutorials, great job and Thanks alot from a guy who is a bit lost in his VB MIS class right now. 

[jmbherer]

Merci :) you are a calm clear and freaky easy to understand....

Many thanks to take the time to share your knowledge.

[petergarcia]

I really appreciate your work, you're good talking and explaining, I'm sorry about my grammar but I'm spanish speaker, anyway thanks for your good work sir!

[sunnimorgan]

That would be awesome. Thank you so much. Your videos are the only thing i have found so far to help me with VSTO. I'm a huge fan! I would love a copy of the project. :)

[kade]

This is a very nice tutorial vdo. I am an absolute beginner. Just following your steps now i can build my own app!

[parvizhajizade]

Thank you for this tutorial. It is very helpful for beginners looking for simple explanations how it should be. We appreciate your work.