Hi All, Is there a way to cache the datagrid and will update datagrid each time got record insert, update to the database?

I don't want my client keep calling to database and retrieve the whole junk of data if there is no changes. Any idea?

So far i've heard about Caching and not sure how is it and never apply to that on my web. Would appreciate if some1 can guide me on this. =(

Whihc database U r using.

You can use SqlCacheDependency for this

Hi Chinz85

If you are using SQL 2005, below is the link on how to use SqlCacheDependency.

http://www.15seconds.com/issue/040518.htm