Login Form in VB.NET Using Stored Procedure | VB.NET

 


Learn how to create a secure and functional Login Form in VB.NET using a Stored Procedure. 

This step-by-step tutorial shows you how to:

1.  Login form design


2. Create Database and table 

CREATE TABLE [dbo].[UserMst] (

    [Id]       INT           IDENTITY (1, 1) NOT NULL,

    [Username] NVARCHAR (50) NOT NULL,

    [Password] NVARCHAR (50) NOT NULL,

    PRIMARY KEY CLUSTERED ([Id] ASC)

);

3. Create SP (Store Procedure) for login

CREATE PROCEDURE [dbo].[sp_login]

@un nvarchar(50),

@pwd nvarchar(50)

AS

BEGIN

set nocount on

select * from UserMst where Username=@un and Password=@pwd

END

4. Test SP

       exec sp_login @un=Admin,@pwd=pass 

       exec keyword than SP name than pass parameter

5. Add "Microsoft.Data.SqlClient" NuGet package and Imports Microsoft.Data.SqlClient I have already added

6. Write logic for login button click event

 Private Sub btnLogin_Click(sender As Object, e As EventArgs) Handles btnLogin.Click

     Dim sqlcon As New SqlConnection("Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Data\Employeedb.mdf;Integrated Security=True")

     Dim sqlcmd As New SqlCommand("sp_login", sqlcon)

     sqlcmd.CommandType = CommandType.StoredProcedure

     sqlcmd.Parameters.AddWithValue("@un", txtUsername.Text)

     sqlcmd.Parameters.AddWithValue("pwd", txtPassword.Text)

     Dim da As New SqlDataAdapter(sqlcmd)

     Dim ds As New DataSet()

     da.Fill(ds)

     If ds.Tables(0).Rows.Count > 0 Then

         btnCancel_Click(sender, e) 'to clear textbox successfull login

         MessageBox.Show("Login Successfull!")

     Else

         MessageBox.Show("Login Fail!")

     End If


 End Sub

7. Write logic for cancel button click event

Private Sub btnCancel_Click(sender As Object, e As EventArgs) Handles btnCancel.Click

    txtUsername.Text = ""

    txtPassword.Text = ""

    txtUsername.Focus()

End Sub

8. Run the application and check



9. If you face any issue please comment below.


🔧 Technologies Used:

  • VB.NET (Visual Basic .NET)

  • Service based database

  • Stored Procedures

  • ADO.NET

  • Visual Studio 2026 (Insider)

  • .NET 10


📌 This video is perfect for beginners and intermediate developers looking to understand database-driven login systems in Windows Forms applications.

👍 Like, Share & Subscribe for more VB.NET tutorials!

💬 Drop your questions in the comments — I’m here to help!



Comments

Post a Comment

Popular posts from this blog

Understanding Middleware in .NET Core

Image
What is Middleware in ASP.NET Core? If you're starting to learn ASP.NET Core , you've probably heard the word "middleware" quite a few times. It might sound complicated at first, but don’t worry — in this post, we’ll break it down into simple terms . You’ll learn: What middleware is Why it's important How it works How to create your own Best practices (and things to avoid) What is Middleware in .NET Core? Middleware is a piece of code that sits between the incoming HTTP request and the outgoing HTTP response in an ASP.NET Core app. It can: Inspect or modify the request Handle authentication or logging Pass the request to the next step Or even stop the request entirely In simple words: Middleware is like a checkpoint that performs some logic on every request before it reaches your controller or API. Real-Life Analogy: The Airport Imagine you're at an airport going through various checks: Security Check (Middleware 1): Checks...
Read more

Database Approaches in .NET Core: Code-First vs Database-First Explained for Beginners

Image
Why Most Beginners Get Confused Choosing a Database Approach in .NET Core?  Beginners often confused - Here are the main reasons why this confusion happens:   1. Too Many Options, Not Enough Context It's common for beginners to feel overwhelmed by the sheer number of data access options in the .NET ecosystem. The key is to understand that these technologies are not competing to solve the same problem. Instead, they operate at different levels of abstraction to address different needs, from raw speed to developer productivity.    2. .NET Learning Curve is Already Steep ASP.NET Core has a lot: Startup, Middleware, Dependency Injection, Routing, Controllers, Services. Adding database decisions (e.g., how to scaffold models or handle migrations) is just another layer on top of all that.   3. Misleading or Fragmented Tutorials Some tutorials say “Use EF Core, it's simple!” Others say “EF is slow, ...
Read more

Dev tunnels

Image
             Dev tunnels allow you to securely expose local web services to the internet, creating a public URL that tunnels traffic directly to your development machine. This is useful for testing, collaboration, and integration with external services Uses of dev tunnel in daily development Debugging and testing on different devices Dev tunnels eliminate the need for complex network configurations when you need to test your application on a separate device. You can access your local server from a mobile phone, tablet, or another computer by simply navigating to the tunnel's public URL.  Integrating with external services and webhook  Many third-party services, like payment gateways, social media APIs, and communication platforms (e.g., Twilio), rely on webhooks to send real-time notifications to your application.  Since webhooks cannot send requests to localhost, you need a public URL to receive them.   A dev tunnel provides a secu...
Read more