Re: Dataset in Session state

From: Vik (viktorum_at_==hotmail.com==)
Date: 02/05/04 

Date: Thu, 5 Feb 2004 16:21:33 -0500

Is it possible to release memory occupied by a Session object? E.g. will
this work: Session("DS") = Nothing ?

Vik

"Hermit Dave" <hermitd.REMOVE@CAPS.AND.DOTS.hotmail.com> wrote in message
news:eyNKMKC7DHA.2712@tk2msftngp13.phx.gbl...
> i see what you mean now.
>
> try using
>
> Session("DS") = DataSet11.Copy()
>
> that way you are explicitly saving a copy. I will have a play around with
> this later on.
>
> --
> Regards,
> HD
> Once a Geek.... Always a Geek
> "Vik" <viktorum@==hotmail.com==> wrote in message
> news:%23hHYK2$6DHA.452@TK2MSFTNGP11.phx.gbl...
> > Thank you Hermit. Here is my code.
> >
> > SqlDataAdapter1 and DataSet11 are created in design time.
> > Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
> > System.EventArgs) Handles MyBase.Load
> >
> > 'Put user code to initialize the page here
> >
> > Dim N0, N1, N2 As Int16, Str1, Str2 As String, DS As DataSet
> >
> > Session("DS") = DataSet11
> >
> > N0 = DataSet11.Tables(0).Rows.Count 'N0=0
> >
> > SqlDataAdapter1.Fill(DataSet11)
> >
> > DS = Session("DS")
> >
> > N1 = DataSet11.Tables(0).Rows.Count 'N1=3
> >
> > N2 = DS.Tables(0).Rows.Count 'N2=3
> >
> > Str1 = DataSet11.Tables(0).Rows(1)(1) 'Str1="Other"
> >
> > Str2 = DS.Tables(0).Rows(1)(1) 'Str2="Other"
> >
> > End Sub
> >
> > So, the dataset is saved in session state only once when it is empty.
> > After
> > the dataset is filled out its saved copy has all the new records. What I
> > need and expected is that the dataset in session state keeps the old
> > records
> > (remains empty in this case) when the real dataset is updated.
> >
> > Vik
> >
> > "Hermit Dave" <hermitd.REMOVE@CAPS.AND.DOTS.hotmail.com> wrote in
message
> > news:%23lauQj36DHA.2576@TK2MSFTNGP11.phx.gbl...
> >> a code snip on how you are trying to use it would help. From my current
> >> understanding here's what i think:
> >>
> >> when you add objects to session they are added by value and not by
> >> reference. ie one that you are refering to in you code is a local copy
of
> >> the object stored session.
> >> any changes to the local copy would not be updated directly. you will
> >> need
> >> to manually update the object in session.
> >>
> >> --
> >> Regards,
> >> HD
> >> Once a Geek.... Always a Geek
> >> "Vik" <viktorum@==hotmail.com==> wrote in message
> >> news:ed5CJv16DHA.804@tk2msftngp13.phx.gbl...
> >> >A dataset is saved in session state. Then the dataset is filled out
with
> >> >the
> >> > new records using a dataadapter. It appears then that the dataset
saved
> > in
> >> > session state contains the new records even without saving the
updated
> >> > dataset.
> >> >
> >> > Why does this happen? How can I preserve the dataset saved in session
> >> > state
> >> > from automatical updating?
> >> >
> >> > Thank you.
> >> >
> >> >
> >>
> >>
> >
> >
>
>

Relevant Pages

  • Re: ASP.NET 2.0 Session_End Question
    ... If the page doesn't use session state, the user won't be identified and no Session object is associated with the request. ... Some web servers are set to recycle daily or even more often, but from the randomness it sounds more like it gets recycled because of some performance problem. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: About Session Object
    ... the session state will be managed ... If using cookies, the session state will be managed with cookies. ... > When is the session object created and by which class,httpruntime or ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Session Variables Disappearing
    ... you have custom controls on that page? ... access session, you need to first get a reference to the session object from ... > Most of the variables that are in the session state are strings, ... how do you cast values you read from the Session object? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Session Variables Disappearing
    ... you have custom controls on that page? ... access session, you need to first get a reference to the session object from ... > Most of the variables that are in the session state are strings, ... how do you cast values you read from the Session object? ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Trouble with huge amount of State Server Sessions Timed out
    ... "Unable to serialize the session state. ... > State Service or SQL Server can be memory intensive depending on the types ...
    (microsoft.public.dotnet.framework.aspnet)