Can i store the Datatable into ViewState with the records of 50,000.

Question

0.00/5 (No votes)

See more:

I am trying to store the datatable in to viewstate so that next time i can get the records from viewstate instead a new query from database, But it is working very good on Localhost but on server it is taking too much time with same code and same SPs.

or tell me is there any other way to do the same thing so that i can get the data from client side without any repeated hits on server.

Posted 11-Jul-13 20:08pm

Ravi Kumar Shakya

Add a Solution

1 solution

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)

Mohammed Hameed · Answer 1 · 2013-07-11T20:50:00

Solution 1

Why you want to store it in a ViewState??

For this kind of scenarios people mostly use sessions as better option. For details check this link: Exploring Session in ASP.NET[^]

Posted 11-Jul-13 20:50pm

Mohammed Hameed

Comments

Ravi Kumar Shakya 12-Jul-13 3:29am

i already told you i want the data only for that perticular search page. then i dont think it will better to store in a session and for every new search viewstate can easily chamge but we cant change session automatically as viewstate.

Mohammed Hameed 12-Jul-13 4:52am

What is the need for 50k records to be fetched at a single time? Cant you reduce it and bring only some minimum set of records.
One more thing, viewstate should not be used for huge data instead you can try using catching.
Also, there is no rule that if data is meant for a particular page then Session should not be used. You can even try once using Session.