How do you set up an API with Webforms with data from stored procedure

How do you set up an API with Webforms with data from stored procedure taking into account that data is dependent on the user login in.  Please remember this is webforms.
Who is Participating?
Paul MacDonaldConnect With a Mentor Director, Information SystemsCommented:
So a user logs in, and you use that user's credentials in the query?  You can store the user name and the fact they've authenticated in session variables, and pass the user name to your stored procedure when you need it.

How much help do you need here?  Info on session variables?  Info on passing parameters to a stored proc?  Info on getting the data back from your SQL server?
Paul MacDonaldDirector, Information SystemsCommented:
This question isn't a question, sorry!  There are at least three different technologies (APIs, web forms, SQL) mentioned and none of them have anything specific to do with each other.

Are you asking how you can create a web form that accesses a database differently based on which user is logged in?  Do you want to create a web service to pass data to authenticated users?
crundle32Author Commented:
Looking to pass data to authenticated users.

Once user authenticated then use the userID  in a storedprocedure along with other values passed and return data REST.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.