Solved

SQL Cache Dependency via page behind

Posted on 2013-01-30
2
224 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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Suggested Solutions

This article discusses the ASP.NET AJAX ModalPopupExtender control. In this article we will show how to use the ModalPopupExtender control, how to display/show/call the ASP.NET AJAX ModalPopupExtender control from javascript, how to show/display/cal…
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…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

733 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