On my Intranet, I have (CLASSIC ASP) pages that pull individual users' info from an SQL source.
The way I pull the correct data is by utilizing the current (per PC) active directory login and binding it to a hidden field.
It is then plugged into my query using request.ServerVariables("Logon_user") as my username field, once a user hits my page, the server variable pulls only their info by matching their current username with my db of usernames.
Once the query is complete, the user will be presented with a personalized page that he or she can make edits on. eliminating the need to use additional login credentials since they're already on the intranet.
How could the results of the above be implemented in asp.net?