I'm trying to connect an ASP.NET to a SQL Server application role but can't
find how to keep the connection between pages.

My initial page asks the user for their SQL Server username and logon.

I then do the following:

Create a connection string using the user's logon and password;
Create a new sqlclient.sqlconnection object using this string.
Create a new SqlClient.SqlCommand object.
Open the connection using the command.
If it opens ok, use the executenonquery command to execute the sp_addapprole
stored procedure on SQL Server (sending the applicaion role and application
role password);
Transfer control to a webform page.

How do I keep the connection when I transfer to the new page?

Graeme