steve potts

steve potts

  • NA
  • 29
  • 10.6k

c# check a record in sql and return the data from the next colum

Oct 8 2012 9:03 AM
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?


Answers (2)