Looking for a way to dynamically direct users to a specific page based on a value retrieved from the database. I'm using forms authentication to direct them to the login page and verify id/password. After they are authenticated, not all users get directed to the same page. The idea is to use a column in the table that's used to verify id/password (for example, "client"), to dynamically redirect them to a client-specific page. I don't know what client they are until I've completed the validation, so the redirection has to be on-the-fly. Any suggestions?

Maybe I'm not understanding the complexities of the problem but can't you just return the desired column from the database (selected by id and password) and store the result. Then have an IF loop (or similar) that calls the response.redirect method for each possible value of the result (e.g. clients, new users, whatever). Then the user would log in, the value would be selected from the database and they would be seamlessly redirected to the correct location.
Is that any help?
Steve

"I will prepare and one day my chance will come."

It may be that simple. I'm not sure.

I'm using the following to redirect them back to the original page after they pass validation -

FormsAuthentication.RedirectFromLoginPage (UserName.Text, Persistent.Checked)

My understanding is that this process also builds the cookie used for authentication. I can certainly replace this with a response.redirect that sends them to the correct page. However, if I have denied anonymous access to the folder containing the page, won't I need the cookie to exist in order for ASP.NET to validate access?

Got this one figured out.

   FormsAuthentication.SetAuthCookie(UserName.Text, false);
   string page;
   page = client + "/ProtectedPage.aspx";
   Response.Redirect(page);

SetAuthCookie creates the cookie for me. Response.Redirect sends me where I need to go. Since I've created the cookie, forms authentication passes.