TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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?
Reply
Answers (
2
)
Inline Table-Value User-Defined Function in SQL
Trigger in Virtual table