Sample Login Module of Visual Basic .Net Project with MS SQL Server 2022 Database

 The video bellow is the tutorial that gives sample of Login module with interface and database interaction using MS SQL Server 2022 Express edition Database.

Here is the sample function code that verify the Login account from the database.

Here is the Code:

 Public Class Login

        Public Function AccountCount(Uname, Pword) As Integer

            Dim rtn As Integer = 0

            Using con = dbConnectConfig.OpenCon

                Dim cmd As New SqlCommand

                cmd.Connection = con

                cmd.CommandType = CommandType.Text

                cmd.CommandText = "SELECT [dbo].[COUNT_UserAccount]('" & Uname & "', '" & Pword & "')"

                rtn = cmd.ExecuteScalar

            End Using

            Return rtn

        End Function

    End Class

To get the sample project, follow the instruction below:

• Go to this link and follow our page. Click Here
• Share one of our facebook Post.
• Comment "I want the project".
• Subscribe to our youtube Channel: Click Here