MS SQL Server

Dynamically Setting the Connection String for Session State on SQL Server

by
SQL Server logo

In ASP.NET, there are four ways to store Session State.  The way I prefer to store it is using SQL Server.  However, instead of storing it in the ASPstate database, which is the default way to store it on SQL Server, I choose to store it in the application database, which is a “custom SQL … Read more

Dynamically Set the ConnectionString Attribute on a SqlDataSource ASP.NET Control

by
ASP.NET logo

I store the connection strings for all three of my environments (development, test, production) in the “connectionstrings” section of web.config on most of my ASP.NET Web applications. When deploying the app to one of these environments, I either have to change a key called “Environment” in the appSettings section of web.config, or I can just … Read more