Solved

SQL Cache Dependency via page behind

Posted on 2013-01-30
2
221 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

777 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