SessionStateSection.SqlConnectionString Property

Gets or sets the SQL connection string.

Namespace: System.Web.Configuration
Assembly: System.Web (in system.web.dll)

public:
property String^ SqlConnectionString {
	String^ get ();
	void set (String^ value);
}
/** @property */
public String get_SqlConnectionString ()

/** @property */
public void set_SqlConnectionString (String value)

public function get SqlConnectionString () : String

public function set SqlConnectionString (value : String)

Not applicable.

Property Value

The SQL connection string. Its default value is the generic string: "data source=127.0.0.1;Integrated Security=SSPI"

This sqlConnectionString attribute is required when Mode is set to SQLServer.

NoteNote:

To use the SQLServer session state mode, you must run the InstallSqlState.sql SQL script (which is installed in [drive:]\WINDOWS\Microsoft.NET\Framework\VersionNumber as part of the default .NET Framework installation) on the computer running SQL Server that will store the session state. This creates a database called ASPState with new stored procedures and creates new ASPStateTempApplications and ASPStateTempSessions tables in the TempDB database.

The following code example demonstrates how to get the SqlConnectionString property. Refer to the code example in the SessionStateSection class topic to learn how to access the SessionStateSection object.

No code example is currently available or this language may not be supported.

Windows 98, Windows Server 2000 SP4, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0

Community Additions

ADD
Show: