Where DataSet is Stored?client side Or server Side.

Question

0.00/5 (No votes)

See more:

C#

ASP.NET

ADO.NET

After fetching the data from database. where the data is store in dataset?cache memory of client side or server side.

Posted 30-Mar-14 8:20am

utm

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Answer 1 · 2014-03-30T08:34:00

Solution 1

As is, it stored nowhere. Web applications are stateless by default. So when your page - in the server side - finishing it's life cycle, all connected data is gone. If you want to use the loaded data between request you have to initiate some kind o caching...
Read here - http://msdn.microsoft.com/en-us/library/system.web.httpcontext.cache(v=vs.110).aspx[^]

Posted 30-Mar-14 8:34am

Kornfeld Eliyahu Peter

Comments

utm 30-Mar-14 14:48pm

if is it nowhere.. then why dataset called an disconnected architecture. and we are able update the dataset record in ado.net. how?
and there is feature of ado.net to searching ,sorting with help of dataview.
so, if it is store nowhere then how these things are posible?

we use dataadper.fill(dataset).
and we use this dataset according to our requirement.like.. to fill the gridview,repeter etc.
now my question is where the data stored in dataset. in server memory or client machine memory.

Kornfeld Eliyahu Peter 30-Mar-14 14:50pm

I'm sorry but I do not understand your question - try rephrase it, please...

utm 30-Mar-14 15:07pm

i rephrase it..if still u not understand my question please reply..

Kornfeld Eliyahu Peter 30-Mar-14 15:16pm

Are you asking where data goes after you fill a DataSet with da.fill? On the server of course. All your code about ado.net is on the server side. However after you finished all you manipulation (search, sort or whatsoever) and your page reaches the unload state all that data is gone...

utm 30-Mar-14 15:41pm

Thank You..

Аslam Iqbal · Answer 2 · 2014-03-30T20:31:00

Solution 2

Actually dataset store nowhere. But during the page life cycle it is stored in server side. Client side holds only html data that can be used when it is postback to server. You can keep dataset or anything in session. Only session (static variable for all user to keep data) can holds data.

Posted 30-Mar-14 20:31pm

Аslam Iqbal

Comments

utm 1-Apr-14 13:51pm

thanks for reply..

Rao Lokesh · Answer 3 · 2014-03-30T20:37:00

Solution 3

Everything Which Comes From Your Database Hand Holding For Some Time Like Session ,Datatable ,ViewState ,Dataset

All are At Stored At Server Side