How do you handle session management in ASP.NET and How do you implement them.

How do you handle session management in ASP.NET and How do
you implement them. How do you handle in case of SQLServer mode?

Question Posted / swapna

1 Answers
6665 Views
DELL, Microsoft, I also Faced
E-Mail Answers

How do you handle session management in ASP.NET and How do you implement them. How do you handle in..

Answer / venugopal

ASP.NET session state enables you to store and retrieve
values for a user as the user navigates ASP.NET pages in a
Web application. HTTP is a stateless protocol. This means
that a Web server treats each HTTP request for a page as an
independent request. The server retains no knowledge of
variable values that were used during previous requests.
ASP.NET session state identifies requests from the same
browser during a limited time window as a session, and
provides a way to persist variable values for the duration
of that session. By default, ASP.NET session state is
enabled for all ASP.NET applications.

We can create the session in Asp.Net is as fallows..

Session["FirstName"] = "venugopal";

In case of Sqlserver session stage we will use the
web.config

In web.config we wills store the session like as fallows

<sessionState
mode="SQLServer"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;user
id=username;password=password"
cookieless="false"
timeout="20" />

Remember that the element names and attributes are case-
sensitive.

This is the most reliable since it's disconnected from the
Web server. This option uses the sqlConnectionString
option. The connection string follows the normal syntax for
connecting to a SQL Server database.