No replies to this topic

[bradploz]

hello, I am trying to connect MS ACCESS 2007 Database with textboxes which will show the info of the users..for example..when I login..I see my info in the textboxes..and when other user logs in..they can see their info..

This is the code I have on load after the window login..

Private Sub frmemp_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Timer1.Start()
        Try
            conn.Open()
            cmd = New OleDbCommand("SELECT * FROM employees,username WHERE ID=IDE", conn)
            dr = cmd.ExecuteReader
            While dr.Read()
                txtfn.Text = dr(1)
                txtpro.Text = dr(2)
                txtsa.Text = dr(3)
            End While
        Catch
        End Try
        dr.Close()
        conn.Close()

    End Sub

But this code only shows the last user on the row on the database..It is not changing even other users login..for example...I login and I am the last user on the row..I can see my info but when other user logs in..He just see my info..Not his...

Please help..and thanks in advance..