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..