I have a very specific development issue.
I have a request from an organization to build an ASP.NET login page with the following specifications:
Must be in VB.NET, Must authenticate using a SQL stored procedure, Login user_id and password are in a preexisting database that I & the user only has READ ONLY access into (so I can only validate off of existing data).
Everything else I have built has either used the ASP.NET configuration tool to create and connect to databases that I have write access on or Intranet sites that use NTauthentication. I'm running into some road blocks on such a seemingly simple request.
Just about every article and video from MSDN, AppDev, & ASP.NET discuss methods I already know and almost always involve the ability to write or modify a database.
I need to capture the user_id & password from the Form login and pass it to the stored procedure on button click (submit) and return a read only results list of database entries associated with that user_id (e.g. Dataset view of a record that the user can print out).
Please include any classes or declarations that might not be standard or tricky.
Thanks So Much.