I can't I need the login information to pull dynamic datasets based off of
who logins in, and need to update a table with the login user id which they
used to log in with, which I carry with a Session variable so that I can use
it in two other queries that are built based off of it.
handle the forms authentication process (assuming you are using forms
authentication) by participating in either
FormsAuthentication_OnAuthenticate or HttpApplicant.AuthenticateRequest
directly. look up the topics in the documentation under forms
authentication, it will tell you how to customize authentication ticket etc
to achieve this.