Refreshing a gridview when the database changes RSS

• • Reply
  

  achalk

  Member

  68 Points

  105 Posts

  Refreshing a gridview when the database changes

  Nov 23, 2012 10:24 PM|LINK

  I have a gridview that has an SQL data table as its datasource. When the data in the table changes (through a separate process) I want the gridview to "auto-refresh".

  How do I achieve this?

  Many thanks.

• • Reply
  

  oned_gk

  All-Star

  31427 Points

  6419 Posts

  Re: Refreshing a gridview when the database changes

  Nov 23, 2012 11:51 PM|LINK

  rebind the gv, or call gv.databind()

  Programming to simplify, dont look for hard way
  • Edited by oned_gk on Nov 23, 2012 11:52 PM
• • Reply
  

  chaaraan

  Contributor

  2170 Points

  484 Posts

  Re: Refreshing a gridview when the database changes

  Nov 24, 2012 01:42 AM|LINK

  Hi,

  You can place the gridview in an update panel and set the timer to auto refresh as shown in  below artcle

  http://stackoverflow.com/questions/10484902/refresh-gridview-without-refreshing-the-whole-page-asp-net

  Regards,

  Charan

  • Marked as answer by achalk on Nov 24, 2012 07:53 PM
• • Reply
  

  achalk

  Member

  68 Points

  105 Posts

  Re: Refreshing a gridview when the database changes

  Nov 24, 2012 07:54 PM|LINK

  Usefukl reference, although it leaves some work for the user. I added the Timer OnTick() event and issued a Databind() inside that method.