SQL Cache Dependency via page behind

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
swgdesignAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
madginoConnect With a Mentor Commented:
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
 
swgdesignAuthor Commented:
Awesome, I'll have a look. I don't think I cam across this tutorial before....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.