Save Session State into SQL Server in ASP.Net

Hi nedash,

Can you share the code where you are trying to save the sqlserver state value in database.

I write this code in command prompt

aspnet_regsql -S serverName -U UserName -P Password -ssadd -sstype p

it will create database sqlstate and it will save sesstion in two table:

USE [ASPState]
GO

/****** Object:  Table [dbo].[ASPStateTempApplications]    Script Date: 11/30/2016 22:21:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ASPStateTempApplications](
	[AppId] [int] NOT NULL,
	[AppName] [char](280) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[AppId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

and:

USE [ASPState]
GO

/****** Object:  Table [dbo].[ASPStateTempSessions]    Script Date: 11/30/2016 22:22:18 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ASPStateTempSessions](
	[SessionId] [nvarchar](88) NOT NULL,
	[Created] [datetime] NOT NULL,
	[Expires] [datetime] NOT NULL,
	[LockDate] [datetime] NOT NULL,
	[LockDateLocal] [datetime] NOT NULL,
	[LockCookie] [int] NOT NULL,
	[Timeout] [int] NOT NULL,
	[Locked] [bit] NOT NULL,
	[SessionItemShort] [varbinary](7000) NULL,
	[SessionItemLong] [image] NULL,
	[Flags] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[SessionId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[ASPStateTempSessions] ADD  DEFAULT (getutcdate()) FOR [Created]
GO

ALTER TABLE [dbo].[ASPStateTempSessions] ADD  DEFAULT ((0)) FOR [Flags]
GO

Hi nedash,

can you share the C# code from where you are passing the session values.

 protected void LBsabt_Click(object sender, EventArgs e)
    { 
        if (DdlCity.SelectedItem.Value != "0" && DdlCity.SelectedItem.Text == "تهران")
        {
            UserData user = new UserData
            {
                Name = Txtname.Text,
                State = DdlState.SelectedItem.Text.Trim(),
                City = DdlCity.SelectedItem.Text,
                Zone = Ddlzone.SelectedItem.Text,
                Mobile = TxtMob.Text,
                Tell = txttell.Text,
                Address = Txtaddu.Text,
                PostCode = TxtcodeU.Text,
                Email = TxtEmail.Text,
                Price = Rbsefareshi.Checked ? LblPostS.Text : LblPostP.Text,
                Sefareshi = Rbpishtaz.Checked ? "پست پیشتاز" : lblfree.Text,
                SefareshiP = Rbpishtaz.Checked ? "پیشتاز" : lblfreeP.Text,
            };
            Session["UserData"] = user;
        }
 else {
                UserData user = new UserData
                {
                    Name = Txtname.Text,
                    State = DdlState.SelectedItem.Text.Trim(),
                    City = DdlCity.SelectedItem.Text,
                    Zone = "-",
                    Mobile = TxtMob.Text,
                    Tell = txttell.Text,
                    Address = Txtaddu.Text,
                    PostCode = TxtcodeU.Text,
                    Email = TxtEmail.Text,
                    Price = Rbsefareshi.Checked ? LblPostS.Text : LblPostP.Text,
                    Sefareshi = Rbpishtaz.Checked ? "پست پیشتاز" : lblfree.Text,
                    SefareshiP = Rbpishtaz.Checked ? "پیشتاز" : lblfreeP.Text,
                };
                Session["UserData"] = user;
            }
        }
      Response.Redirect("پرداخت-مبلغ-خرید.aspx");
    }

Hi nedash,

The class UserData's object which you are using to save in session need to be serialize and page class too need to be serialize from where you trying to save the data to session so kindly make your UserData Class and Current Class Serialize for eg.

[Serializable()]
public class UserData //your class.
{
    //Your Data.
}

[Serializable()]
public partial class YourCurrentPageClass
{
   protected void LBsabt_Click(object sender, EventArgs e)
   {
       if (DdlCity.SelectedItem.Value != "0" && DdlCity.SelectedItem.Text == "تهران")
       {
           UserData user = new UserData
           {
               Name = Txtname.Text,
               State = DdlState.SelectedItem.Text.Trim(),
               City = DdlCity.SelectedItem.Text,
               Zone = Ddlzone.SelectedItem.Text,
               Mobile = TxtMob.Text,
               Tell = txttell.Text,
               Address = Txtaddu.Text,
               PostCode = TxtcodeU.Text,
               Email = TxtEmail.Text,
               Price = Rbsefareshi.Checked ? LblPostS.Text : LblPostP.Text,
               Sefareshi = Rbpishtaz.Checked ? "پست پیشتاز" : lblfree.Text,
               SefareshiP = Rbpishtaz.Checked ? "پیشتاز" : lblfreeP.Text,
           };
           Session["UserData"] = user;
       }
else {
               UserData user = new UserData
               {
                   Name = Txtname.Text,
                   State = DdlState.SelectedItem.Text.Trim(),
                   City = DdlCity.SelectedItem.Text,
                   Zone = "-",
                   Mobile = TxtMob.Text,
                   Tell = txttell.Text,
                   Address = Txtaddu.Text,
                   PostCode = TxtcodeU.Text,
                   Email = TxtEmail.Text,
                   Price = Rbsefareshi.Checked ? LblPostS.Text : LblPostP.Text,
                   Sefareshi = Rbpishtaz.Checked ? "پست پیشتاز" : lblfree.Text,
                   SefareshiP = Rbpishtaz.Checked ? "پیشتاز" : lblfreeP.Text,
               };
               Session["UserData"] = user;
           }
       }
     Response.Redirect("پرداخت-مبلغ-خرید.aspx");
   }
}