Re: DataAdapter update

From: Girish bharadwaj (girishb_at_mvps.org)
Date: 09/13/04 

Date: Mon, 13 Sep 2004 09:35:59 -0400

Following are the options for states in ASP.NET.
1. Cookies.
2. ViewState
3. Session state
4. Application
5. Cache

Among these, if you dont want to use session state, you can probably use
Application or Cache. I recommend Cache since that will basically take care
of cleaning up old items.

You might be able to use ViewState too but you will need to test to make
sure that it does not cause much problems. 

-- 
Girish Bharadwaj
http://msmvps.com/gbvb
"Janaka" <janaka@magicalia.com> wrote in message
news:OCTiTFYmEHA.3896@TK2MSFTNGP15.phx.gbl...
> I tend to use the SqlDataAdapter class in WinForms projects because once
the
> inital data is loaded any modifications can be easily added/updated
through
> a call to the Update() method.  I've found in aspnet that the same thing
is
> possible but because of the stateless nature of the web in order to do
this
> I have to go through the following steps:
>
> 1. First visit to page loads DataSet and binds DataList with data
> 2. User edits data and submits the pages
> 3. Reload the DataSet with original data as in 1.
> 4. Iterate through the DataList and updates rows in the DataSet
> 5. Call the Update() method to update edited rows
>
> Now am I doing this correctly or is there any way I can skip step 3?  It
> seems easier to just update each row in the DataList than go through the
> process of only updating modified rows.
>
>
>

Relevant Pages

  • Re: caching: Session state or Application state...
    ... > 1) When is memory used for Session State freed? ... > - if my cache item expires due to it reaching it's expiration time - is ... the type of cahcing and the expiration policy can see ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Session State vs. What?
    ... you can use Session state (still works in .NET and has more ... The cache has the advantage of being very fast. ... I would have to query the database first then ... > function due to overhead on the server, ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: ViewState, Application, Session....
    ... viewstate and as a part of Request pipeline the framework initializes the ... Session: Session is a storage area that is specific to one user. ... there are times when session provides a good way to store user specific ... Application or Cache: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Storing a datatable in application or session state?
    ... I said session state but meant viewstate. ... >>> luck with session state rather than viewstate which is why I'm asking, ... I thought simply that one is for server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: 3rd party application, cache and session state
    ... that the app uses cache (with sql server 2000) and Session States. ... Session State Boolean 3 ... Session State String 6 ...
    (microsoft.public.dotnet.framework.aspnet)