c# check a record in sql and return the data from the next colum
hi all, my app already reads and writes to mysql, so i guess this is going to be a good way for me to achieve this next part.
What i have is a seperate system, where the usernames are different from my domain usernames.
given that i can get the current windows logon easy, what i have done is made a small table in my DB, containing a list of domain usernames, and the other database usernames.
what i need to do is get match my windows username in the database and return the other username which is in the next colum.
my table is like this
ID -- Win_UN -- DB_UN
1 -- bill.gates -- billg
i want to get the billg bit :P
any help?