VB.NET Database Tutorial - Login Screen For A SQL Database Application (Visual Basic .NET)

In this VB.NET tutorial I will teach you how to create a functional SQL database login application with case sensitive password checking. We'll learn how to establish and test our database connection, authenticate users against table records, and display user information on our form.

TUTORIAL FEATURES:
Class Design - SQLControl class for managing SQL connections and queries
Functions - User authentication, Database Connectivity
Subs - Database Queries
Form Controls - Button, GroupBox, TextBox, Label

[tonnab]

Excellent explanation. Many thanks. I am using webform instead of windows form and it does still work perfectly apart from a very slight different properties between them.

[AzharKalamazhar]

@22:10 Close the door after you leave. Made my day! You are champ :)

[sonytv]

Hello VbToolbox

I've paid 110$ for tutorials which are not even close like quality to yours.
Amazing member Thank you so much for your tutorials.
I really appreciate your work.
Very friendly way of explanation!

[technousr]

This was an awesome tutorial as I appreciate the details that you go through. I did have one follow up question regarding the AuthUser variable and how it would be used. After the user has been authenticated, what would you need to use the AuthUser variable for since you are using a system account to execute any SQL with the database?

[mukeshkhan]

Really awesome bro.. Thank you so much

[Cleptra]

Hello, thanks a lot please for you have really helped me. Im working on my final year VB.Net project for an accounts management system and these clips have been wow. Thank you

[none]

You should have way more views and subscribers than what you currently have!

[marksindao]

learned important things here. thanks. God bless

[SimperYT]

Thank you so much for this tutorial. It really helped me a lot. You Are Awesome!

[אלישאול-סנ]

I enjoyed very much, thank you, keep doing good movies

[Kevisinthahouse]

Really helpful, starting my own project now.

[KhainStakard]

Cheers from Brazil! Awesome video, I really liked your solution using functions, you opened my mind! :)

[rexjanbevmercado]

i always watch your video it is very helpful and i wish you notice this but i need your help, make a video of login screen with a MS Access like continue of other tutorial of MS Access THanks A lot

[CubingChris]

"Give me likes.. and stuff" :'D
Thanks fo the vid! was very helpful :)

[pconstantinos]

By the way I'm using part of you Combo Box tutorial to populate a Combo Box of User Names and your Login Tutorial to check for the authentication of the UserName and Password. 

[edwardesmalin]

The wait is over, thank u so much  sir for you"re  kindness=)...

[khalidabdulwahid]

very informative for beginners like me, could u please tell us how to work with different user authorities like add, del, edit

[pconstantinos]

Hello again,
In your Login Tutorial you check for the User Name & Password and by the way this is great. I would like to expand on this and grab additional data from the Users table and store it in a few variables. Like Admin Access or Settings which are booleans. Your if statement in the IsAuthenticated function looks at Table(0).Rows(0), Item("UserCount")=1 can I add to that once it returns True or should I call another Function to extract the other data. Its a bit like your Combo Box Tutorial but with a few additional fields. I hope this makes sense.
Thanks and keep up the Great work.

[benlil]

Your videos have been very informative, I was wondering if you can make a in-depth tutorial about vb.net crystal report generation from db sql server with dynamic queries.

[monib]

Hi VB Toolbox  great tutorials easy to follow along and get it done, thank you for that. Just a quick question on connection string. I have a ms access db in the project solution, would you know the connection string for that. Its not running on server. Thank you