Authentication/Credentials

[NovCoder]

HI, Can anyone help my ignorant self retrieve a username from a SQL database.

Situation: each person has a login name and full name in the database. When someone logs in I would like a txtbox display that login's full name. I haven't got the slightest idea what to do. what ever you can offer(HELPFUL codes, HELPFUL links, HELPFUL websites) would be greatly APPRECIATED

THANX

...and I'm out. O-BOY.

 

[Mastakilla]

how about this:

http://www.w3schools.com/sql/default.asp

 

[jgobrien]

Do you have a 'user information' table that contains the SQL Server username and full name?

You will need such a table to store additional user information.


Then all you need to do is:
SELECT FullName FROM UserInformation WHERE Username LIKE 'me'