[faisalmukhtarch]

Iam using this code to get the Staff ID from which i login but iam getting the Staff Name of some other data.
Help needed

con.Open()
        sql2 = "Select * FROM Staff "
        cmd = New OleDbCommand(sql2, con)
        dr = cmd.ExecuteReader
        dr.Read()
        txtStaffID.Text = dr.Item("Staff ID")
        dr.Close()
        con.Close()

[lucky3]

Try to change your lines 5 and 6 with:

        'make sure you have multi-line textbox
        While dr.Read()

            txtStaffID.Text &= dr.Item("Staff ID")

        End While

[smohd]

I see two things there:
- First, did you say "but iam getting the Staff Name"? I think you mean staff id right?

- Then you are querying all rows rows, how can you get the one you logged in by? Simply here you will have to catch the id of the one who loged in in login process, then store it in a variable for letter usage. This will simplify a lot of those troubles...