Passing Variable

Question

Hi folks,

New to winforms. I have managed to get a winform login form (Form1) running where i have users authenticate against a username/password that is stored in a SQL Server 2005 Database. If they authenticate, then Form2 will show, if not, an incorrect username/password message is displayed.

On form2, i have created a datagrid which shows all data from a table in SQL Server. It shows all employee course history data for all employees.

I would like when the user logs on, that the datagrid only shows the records in the datagrid for that logged in user only and not the records for all employees.

How can i take the input details (username/password) from the current user logged in and only show them their records in the grid on Form2.

Basically, I would like to pass the username that the user typed in Form1 to Form2 so i can try to pass the username into the SQL query to bring back only that employees records.


This is the current code for Form 1 below:


Public Class Form1
Inherits System.Windows.Forms.Form

Private Sub SimpleButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SimpleButton1.Click

        Dim login = Me.ELoginTAdapter.UsernamePasswordString(txtusername.Text, txtpassword.Text)
        If Login Is Nothing Then
            txterror.Text = "Incorrect Username or Password"
        Else
            Me.Hide()
            Form2.Show()
        End If
       
End Sub
End Class

Any help is appreciated.