troubleshooting Question

ASP.Net Form Authentication with SQL Stored Procedure

Avatar of jcf3682
jcf3682Flag for United States of America asked on
Visual Basic.NETMicrosoft SQL Server 2008
3 Comments1 Solution680 ViewsLast Modified:
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros