So how would I turn the above code into a stored procedure and get the info.

I have looked around several pages on google, but they all want to put the info into a datagrid, which all I want to do is put the info into some text boxes on the web form.

Been looking at everything about stored procedures but I am still a little confused on how they work.

I know I need an input (@empID) and several outputs for the user name, email and store. How do I go about creating the SP with this in mind?

Then how do I assign what was read to text boxes on the form?