Public Sub login()
        SQLConnection.ConnectionString = ServerString
        cmd.Connection = SQLConnection
        cmd.CommandText = "SELECT employee_id, password FROM employees_list WHERE employee_id='" & Form1.EMPLOYEE_ID_txt.Text & "' and password='" & Form1.PASSWORD_txt.Text & "'"
        dr = cmd.ExecuteReader()
        If dr.HasRows Then
            Form1.PASSWORD_txt.Text = ""
            MessageBox.Show("Signed in", "", MessageBoxButtons.OK, MessageBoxIcon.Information)
'get firstname and lastname"
label4="firstname lastnamee"

        ElseIf Form1.PASSWORD_txt.Text = "" Or Form1.EMPLOYEE_ID_txt.Text = "" Then
            MessageBox.Show("Please complete the required fields..", "Authentication Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
            MessageBox.Show("Username and Password do not match..", "Authentication Failure", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
            'Clear all fields
            Form1.PASSWORD_txt.Text = ""
            Form1.EMPLOYEE_ID_txt.Text = ""
        End If
    End Sub

im making a login form where the user types the employee id and password
if both fields are true how can i get the values of firstname and lastname from sql?

sorry for my english.

You are not pointing to your tabase location, something like:

 AccessConnect = "Driver={Microsoft Access Driver (*.mdb)};" & _
                     "Dbq=nwind.mdb;" & _
                     "DefaultDir=C:\program files\devstudio\vb;" & _
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.