How to Connect Visual Basic .Net Project to MS SQL Server 2022 Database

 This tutorial helps viewers to connect Visual Basic .net Project to MS SQL Server 2022 Database using the settings of the project and connection string.

Here is the sample function code that allow to connect your database to your VB.net Project

Here is the Code:

Imports System.Data.SqlClient

Module dbConnectConfig

    Public Function OpenCon() As SqlConnection

        Dim con As New SqlConnection(My.Settings.Mycon)

        If con.State = ConnectionState.Open Then con.Close()

        con.Open()

        Return con

        con.Close()

    End Function

End Module

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 

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 

How to create Textbox with Suggestion Text

Here are the steps to use textbox with suggestion text input by user.

1. Drag and Drop the Textbox from Tools panel into GUI Form.





2. Design and Change the properties of the Textbox control like Name and Text Properties.

Buy Restaurant POS Sample

Point of Sale System(POS) is a Computer software that develop by many programmers to help the restaurant upon managing the Sales. This software can generate Daily Sales, Monthly Sales and even the yearly Sales. The Items or the product encoded to the database has been organize and easy to update the new prices and other details to be modify.

Here is the image of Sample Point of Sale System.

User Login Windows

Security Guards Hiring

SOCOPA Security Agency, Incorporated 

Purok Malakas, San Isidro, General Santos City

Qualification:

• Male/Female
• 18 years old Above and not more than 40 years old .
• at least High School Graduate

Requirements: