use dataset on application level

Posted by Ermahesh2009 under ASP.NET on 6/29/2012 | Points: 10 | Views : 1406 | Status : [Member] | Replies : 1
I have a requirement where I need to handle a set of tables with some smaller number of rows. And the chance of these rows getting updated is very low, So I don't want to visit the database now and then. Basically these tables are used to fill drop-downs on every pages.

I am thinking the way where put records in an application level dataset on application load event and use it across the application

Is this is right way to do this or there is some other way/technology where we may fulfill our requirement ?


Posted by: Jeffie on: 6/29/2012 [Member] Starter | Points: 25

Instead having it in the Application Load Event.
You can implement in the Global.cs with a static method and store that dataset in a session variable which you can access through out the application
for further if you need to modifications you can update that session'


Ermahesh2009, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response