Session state using SQLSERVER

[PPCC]

Hi
I am tring to store session variables in sql server
for that i have made following cjanges:
in web.config:
and run InstallSQlstate.sql from this folder
C:\WINNT\Microsoft.NET\Framework\v1.0.3705

i have witten following code for this
private void Button1_Click(object sender, System.EventArgs e)
{
Session["Se"]= TextBox1.Text;
Response.Write(Session["Se"].ToString());

}

Now I am not able to store my session data is sql Server.
can anybody know..anything more to do to get session data.

thanks in advance.

PPCC

[Waseemalisyed]

Save Value in Cookies
for store value
Response.Cookies["SessionName"].Value = textBox.text;

for get value

string SessionID = (string)Request.Cookies["SessionName"].Value;

[PPCC]

it means i can't store values in SQL server...then what is this SessinState element in web.config file does

[Waseemalisyed]

no u can also store in SQL server but its better put valuse in session variable

EnableSessionState="false"

[PPCC]

hey man i don't understand where to write EnableSessionState="false neither page nor web.config allowed.

[Waseemalisyed]

<%@ Page language="c#" Codebehind="SignIn.aspx.cs" AutoEventWireup="false" Inherits="Sample.Web.SignIn" EnableSessionState="false" EnableViewState="false" %>

IN html Portion

[oldbear]

Hi PPCC

What error messages do you get when you try to save to the sql server session state?

Chris Seary

[PPCC]

Hi PPCC

What error messages do you get when you try to save to the sql server session state?

Chris Seary

No error message but can't stored value in SQL server.

[mendhak]

Did you add:

<sessionState
  mode="SQLServer"
  sqlConnectionString="data source=server;user id=uid;password=pwd"
  cookieless="false" timeout="20" />

in web.config?

[PPCC]

Did you add:

<sessionState
  mode="SQLServer"
  sqlConnectionString="data source=server;user id=uid;password=pwd"
  cookieless="false" timeout="20" />

in web.config?

yes i added that in web.config file..but no luck

[PPCC]

hi buddies,I am looking in ASPStateTempSessions table..Hope session data get stored here.