Dim strConn As String = "Provider=SQLOLEDB.1;Password=xxxx;Persist Security Info=True;User ID=xxxx;Initial Catalog=xxxx;Data Source=xxxx"
Dim strsql As String = "SELECT FirstName + ' ' + LastName AS Name FROM tblStaff WHERE LoginID = " + username(1)
Dim myconn As New OleDbConnection(strConn)
Go to the complete details ...