How to store datatable in cache to reuse it?

In my application i have used Generic handler to serve requests.

I want mechanism like if the first time request comes to handler ,it makes a request to server and then Cache whole datatable, so for upcoming request if the next requested productcode is exist in the datatable of cache, it should not go to server for fetching data should check data of datatable only.

So can you explain me how can i set datatable in cache.??


Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

Something along these lines?

public DataTable GetDataTableFromCacheOrDatabase()
   DataTable dataTable = HttpContext.Current.Cache["secret key"] as DataTable;
   if(dataTable == null)
       dataTable = GetDataTableFromDatabase();
       HttpContext.Current.Cache["secret key"] = dataTable;
   return dataTable;

You’re going to need some mechanism to flush the data table from the cache if it changes. For example you could use an SqlCacheDependency.

As requested, to clear the cache an hour after the table is added you would do:

HttpContext.Current.Cache.Insert("secret key", dataTable, null, DateTime.Now.AddHours(1), System.Web.Caching.Cache.NoSlidingExpiration);

Method 2

try this

 DataTable mytable;
 String key = "key"
 if(HttpContext.Current.Cache[Key] ==null)
        mytable = GetDTFromDB();
        if(mytable.Rows.Count > 0)
            HttpContext.Current.Cache.Insert(strKey, mytable, Nothing, DateTime.Now.AddHours(1), System.Web.Caching.Cache.NoSlidingExpiration);
        mytable = HttpContext.Current.Cache[strKey];

Method 3

you can use:

HttpContext.Current.Cache["CacheDataTableID"] = datatableInstance;

Method 4

you can write a property for your table like

public DataTable CachedTable  { get{ 
      if(Cache["CachedTable"] == null) 
       Cache["CachedTable"]= //get from databse 
      return Cache["CachedTable"]; 
    }  }

All methods was sourced from or, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes
Article Rating
Notify of

Inline Feedbacks
View all comments
Would love your thoughts, please comment.x