Dataset caching in asp.net and assigning to cascading dropdown list?

Question

0.00/5 (No votes)

See more:

Hi all,

I have a scenario like this. I have 4 dropdown list boxes which will cascade depending on the selection made in the previous dropdown list.

For instance keep my first dropdown list as country, second dropdown list as state and third dropdown as districts. For eg. If i select India, then the states must be loaded. Then if select Gujarat, then the districts must be loaded.

I am using a "Ajax Cascadedropdown" to do this.

This i have do in "Caching" concept. When the page is loaded for first time the total data for all four dropdown lists must be loaded as a "dataset" and stored in a "cache". So that when I select Country in first dropdown the data for the second dropdown must be loaded from the cache itself. So that the page will not be posted back. Even if i refresh the page will not go to database to fetch the data again. This will make the page performance is increase rapidly.

I am new to caching concept. So if could help to solve this issue with detailed code it would be great of you

Thanks in advance,
Naveen.

Posted 11-Jul-13 20:07pm

Nrajmec

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)

Priyanka7777 · Answer 1 · 2013-07-11T20:39:00

Solution 1

Check if this helps you:

C#

Cache["data"]=ds; //ds is your dataset name.

Posted 11-Jul-13 20:39pm

Priyanka7777

Comments

Nrajmec 12-Jul-13 3:27am

Thanks for taking interest in answering my ques.

I got this but i dont know how to retrieve the value from cache, when a user selects a value in the first dropdown list and to load the corresponding value in second dropdown.

Priyanka7777 12-Jul-13 3:35am

Check out this link which shows how to Retrieve Values of Cached Items.

http://msdn.microsoft.com/en-IN/library/xhy3h9f9(v=vs.100).aspx