i was able to successfully connect my database using connection string, i am having a hard time finding tutorials on how to add the items in a textbox.

Imports System.Data.SqlClient
Public Class FrmMain
    Private Sub FrmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        
        Dim sqlconnection As New SqlConnection

        sqlconnection.ConnectionString = "server = PAL\SQLEXPRESS; Database=BESdb ; integrated security=true"

        Try
            sqlconnection.Open()

        Catch ex As Exception
            MsgBox("Connection to SQL Server Failed")
                
        End Try
    
    End Sub