Session <sessionState mode="SQLServer" ..

Question

4.00/5 (1 vote)

See more:

Hi All,
I m using session in my website. I have used mode=SQLServer, like following.

C#

<sessionstate mode="SQLServer" ....

Now as i save some thing in session, i can see row with value in my sqlserver's 'ASPStateTempSessions' table. But as I set value for session and close the browser i am not able to get the session value back. If it is saved in sqlserver it must comes?

Please help.

Posted 28-Dec-13 3:54am

Brijesh Kr

Updated 28-Dec-13 3:59am

v2

Add a Solution

Comments

ZurdoDev 28-Dec-13 11:10am

What? This is not clear.

Sampath Lokuge 28-Dec-13 11:47am

Check this article : http://www.itorian.com/2012/09/aspnet-session-states-in-sql-server.html

joginder-banger 28-Dec-13 12:48pm

sorry what's you try??

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sampath Lokuge · Answer 1 · 2013-12-28T06:05:00

Nope.You're wrong here.When you close the browser, you cannot get that session again.The idea of storing session on Sql server is the scenario where you have a web farm for your app.At that time even though your one of the IIS server down, still you can access the session which you stored on db by using downed (failed) IIS server.But you cannot do this by using default in process session.

Please read below mentioned article for more info:

How to use ASP.NET session state SQL Server Mode in a failover cluster