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 the Difference Between Controller and ControllerBase in ASP.NET Core

Image
  Understanding the Difference Between Controller and ControllerBase in ASP.NET Core   What are Controllers in ASP.NET Core? In ASP.NET Core, controllers are the classes that handle incoming HTTP requests from clients (like web browsers or apps) and decide how to respond. They are an essential part of the MVC (Model-View-Controller) architecture and Web API development. Controllers receive input, interact with the application's business logic or data, and then return a response—this could be an HTML page, JSON data, a file, or even a redirect to another page. They act as the “middleman” between users and your application's backend.   Why Controllers Matter in Web Apps and APIs Controllers play a crucial role because they determine how your application communicates with the outside world: In web applications, controllers render views (HTML pages) that users see in their browsers. They make websites interactive by handling forms, navigation, and user input. ...
Read more

Creating an executable installer (.exe) in Visual Studio

Image
Creating an executable installer (.exe) in Visual Studio allows you to package your application for easy distribution and installation on other computers. This is typically achieved by using a "Setup Project." Here's a comprehensive guide on how to create a setup `.exe` in recent versions of Visual Studio. Create installable exe file from windows form application in visual studio using setup project 1. Open your Windows Forms application project in Visual Studio. 2. Make sure your project builds successfully by clicking on "Build" in the top menu and selecting "Build Solution" (or pressing Ctrl+Shift+B). 3. Right-click on the solution in the Solution Explorer, select "Add" > "New Project" or go to "File" > "Add" > "New Project". 4. In the "Add New Project" dialog, select "Setup Project" under the "Other Project Types" > "Setup and Deployment" category....
Read more

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