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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
Paul MacDonaldDirector, 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?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.