I have an ASP.net application and I need to authenticate a user against an SQL database. Essentially, there is a button click that occurs on a demographic information form. There is an SQL table called 'users', which contains the authorization code and the real name of each authorized user. I have a textbox control on the page called 'txtCode' and I want the person to enter their code and then when the button click occurs, I want to validate this code they have entered against the 'user' table in SQL.
If validation is successful:
1. their real name as associated with their code they entered will show up in a textbox called 'username'