How to refresh an ASP.NET GridView automatically at regular intervals




A common requirement is to refresh the GridView after regular intervals. ASP.NET contains the Timer control which comes in very handy to achieve such requirements. Here's how to do so:

Add the GridView and the Timer control inside an ASP.NET AJAX UpdatePanel as shown below :


<asp:UpdatePanel ID="UpdatePanel1" runat="server">


<ContentTemplate>


<asp:Timer ID="Timer1" runat="server" Interval="3600" ontick="Timer1_Tick"></asp:Timer>


<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataKeyNames="CustomerID"


DataSourceID="SqlDataSource1" AllowPaging="True" AllowSorting="True">


<Columns>


<asp:BoundField DataField="CustomerID" HeaderText="CustomerID" ReadOnly="True" SortExpression="CustomerID" />


<asp:BoundField DataField="CompanyName" HeaderText="CompanyName" SortExpression="CompanyName" />


<asp:BoundField DataField="ContactName" HeaderText="ContactName" SortExpression="ContactName" />


<asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" />


<asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />


</Columns>


</asp:GridView>


</ContentTemplate>


</asp:UpdatePanel>




Then in the code behind, add the following code which refreshes the GridView after every minute

C#


protected void Timer1_Tick(object sender, EventArgs e)


{


GridView2.DataBind();


}




VB.NET


Protected Sub Timer1_Tick(ByVal sender As Object, ByVal e As EventArgs)


GridView2.DataBind()


End Sub




Will you give this article a +1 ? Thanks in advance




About The Author

Suprotim Agarwal, ASP.NET Architecture MVP works as an Architect Consultant and provides consultancy on how to design and develop Web applications.

Suprotim is also the founder and primary contributor to DevCurry, DotNetCurry and SQLServerCurry. He has also written an EBook 51 Recipes using jQuery with ASP.NET Controls.

Follow him on twitter @suprotimagarwal

comments

13 Responses to "How to refresh an ASP.NET GridView automatically at regular intervals"
  1. Anonymous said...
    October 15, 2009 at 3:44 PM

    Thank you and best of luck with the book.

  2. Anonymous said...
    June 16, 2010 at 3:49 AM

    sank youu

  3. Rickson Menezes said...
    November 25, 2010 at 2:09 AM

    Gives me an error, Update Panel requires ScriptManager

  4. Rickson Menezes said...
    November 25, 2010 at 2:25 AM

    I added a script Manager tag just above the Update Panel and it worked. It was updating my gridview every x seconds

  5. Anonymous said...
    December 12, 2010 at 6:07 PM

    Hello, im getting a PageRequestManagerParseErrorException, i have the code just like you suggest, what might be going wrong?

    Thank you.

  6. Suprotim Agarwal said...
    December 12, 2010 at 7:07 PM

    For the PageRequestManagerParseErrorException error, try this link

    http://weblogs.asp.net/leftslipper/archive/2007/02/26/sys-webforms-pagerequestmanagerparsererrorexception-what-it-is-and-how-to-avoid-it.aspx

  7. Anonymous said...
    April 5, 2011 at 5:08 AM

    some of the function within the grid not work??

  8. Rahul Ostwal said...
    October 5, 2011 at 3:16 AM

    I am filling data after every 5 min. but by this code first time it take 5 min. to fill grid. how to avoid this?

  9. Pål Sølvberg said...
    June 19, 2012 at 12:11 AM

    Hi Rahul.
    You just have to fire the Databinder code in PageLoad, like this:

    protected void Page_Load(object sender, EventArgs e)

    {

    GridView2.DataBind();

    }

  10. Anonymous said...
    August 6, 2012 at 3:14 PM

    LO MAS GRANDE MUCHAS GRACIAS!!!!!!!!!!!!!!!!!!!!!!!!!

    FCP

  11. Anonymous said...
    January 3, 2013 at 4:00 AM

    Simply gr8.........

  12. DIM said...
    December 20, 2013 at 12:22 AM

    Thanks for great article!!!!What we can do if we have 2 datagridviews and we want update every 5 seconds with different select commands both???

  13. Alex Segura said...
    July 22, 2014 at 12:24 PM

    Appreciate it!

 

Copyright © 2009-2014 All Rights Reserved for DevCurry.com by Suprotim Agarwal | Terms and Conditions