Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Cache Dependency via page behind

Posted on 2013-01-30
2
Medium Priority
?
231 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 2000 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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…
IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

877 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