I am working on a project that requires me to hop into to separate DB's.

So I have figured that I need to have multiple functions inside of my VB page.

The only problem I am having,is I am not to sure how to get this all accomplished.

So far I have figured out the overall structure, just need help implementing that structure.

Here is my idea:

The main Function would call two other functions. We can Call them Sub Function 1 and Sub Function 2.

So, the main Function takes the saved sessions information for the E-mail address and dumps in into Sub Function 1. It needs to open up a new connection to the db/stored procedure and RUN the following procedure and then return the result. Here is the stored procedure and what i think is correct.

CREATE PROCEDURE WEB_User
(
    @EMAIL_ADDRESS varchar(80) = [EMAIL_ADDRESS]
)
AS
SELECT
    MEMBER_NUMBER
FROM
    WEB_LOGIN
WHERE
    EMAIL_ADDRESS = @EMAIL_ADDRESS

So my question is, what is the function suppose to look like? how do I send the session information to the procedure? and finally, how do I return the stored procedure results and push back into the main function so it can be carried into sub function 2?

Thank you in advance for your help... I really appreciate it!