How to update datagrid if there is update on the DB?

Home ›

ASP.NET Forums » General ASP.NET » State Management » How to update datagrid if there is update on the DB?

Shortcuts

Previous Next

How to update datagrid if there is update on the DB?

Last post 09-01-2008 1:22 AM by cliquerz. 2 replies.

Sort Posts:

How to update datagrid if there is update on the DB?

08-28-2008, 6:33 AM

Contact

2 point Member
chinz85
Member since 08-13-2008, 2:07 AM
Posts 11

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. =(

Re: How to update datagrid if there is update on the DB?

08-28-2008, 6:44 AM

Contact

9,462 point Star
kamii47
Member since 05-26-2005, 4:04 PM
Karachi, Pakistan
Posts 2,201

Whihc database U r using.

You can use SqlCacheDependency for this

Kamran Shahid
Sr. Software Engineer
(MCP,MCAD.net,MCSD.net,MCTS,MCPD.net[web])

Remember to click "Mark as Answer" on the post that helps U

Re: How to update datagrid if there is update on the DB?

09-01-2008, 1:22 AM

Contact

Answer

329 point Member
cliquerz
Member since 09-02-2007, 8:54 PM
Philippines
Posts 52

Hi Chinz85

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

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

Don't forget to tag me as an answer if it helps you.

-------------------------------------------------

Everyone lives in one of two tents: Con-TENT or discon-TENT

Page 1 of 1 (3 items)

RSS Available