sessions

Lost User

hi, can anyone help me on the following? I want to save all the sessions along with its data into sqlserver database. After that I want to fetch n display on UI.

Sandeep Akhare

Are you asking for the code ? No you should try this by searching google Any way One way is put the content of the session in dataset and push that dataset in database table.

Thanks and Regards Sandeep If If you look at what you do not have in life, you don't have anything, If you look at what you have in life, you have everything... "

rashidpervaiz08

Go to command mode and go \WINDOWS\Microsoft.NET\Framework\v2.0.50727 run aspnet_state.exe with appropiate parameters, then configure your web.config. Muhammad Rashid

John ph

rashidpervaiz08 wrote:

Go to command mode and go \WINDOWS\Microsoft.NET\Framework\v2.0.50727 run aspnet_state.exe with appropiate parameters, then configure your web.config.

did you read the post before responding? I don't think this will solve his problem.

Regards
J O H N :rose:
"Even eagles need a push." David McNally

John ph

Create a Table in the SQL Server to store the session values. If you already have one then....otherwise You decide the structure of the table. In the front-end to collect the session values use Session.Keys collection class and add the key and values to the DataTable. store it to the Database. Here is a way how to read the session Values...

Dim Key, SessionKey, SessionValue As String
For Each Key In Session.Keys
  SessionKey = Key
  SessionValue = Session(Key)
  'Add the userId, SessionKey and SessionValue to the Table
Next

Regards
J O H N :rose:
"Even eagles need a push." David McNally

rashidpervaiz08

so true