Connecting ASP.NET to SQL Server Application Roles

[Graeme]

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

 

[Sin Min]

Hi!

Before you move to the next page, I believe you have closed the connection
(best practise to close every connection after use). You then have to open
the connection again in your 2nd page if data access is required.


Regards,
Sin Min