Solved

SQL Cache Dependency via page behind

Posted on 2013-01-30
2
223 Views
Last Modified: 2013-02-11
I have enabled sql cache dependency for one of my SQL tables and have setup my database as per this article:

The one thing I cannot seem to figure out is how to do the coding for the cache dependency pooling from the page behind using say a datatable, and not using a datasource object as the tutorial does.

Can anyone help me with this please?

THanks
0
Comment
Question by:swgdesign
2 Comments
 
LVL 11

Accepted Solution

by:
madgino earned 500 total points
ID: 38834400
Your link to your example article is not visible but you have here a post that shows you how to do it in page too:
http://www.dotnetfunda.com/articles/article1382-how-to-implement-sql-caching-in-aspnet-poll-based-sql-cache-dependency.aspx

Basically a datatable is a valid datasource for objects so you just have to assign it:

 GridView1.DataSource = table;
 GridView1.DataBind();
0
 

Author Comment

by:swgdesign
ID: 38834460
Awesome, I'll have a look. I don't think I cam across this tutorial before....
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question