How to refresh an ASP.NET GridView automatically

Question

3.67/5 (2 votes)

See more:

Hi i have a grid with 500+ records and the data values in the grid are updated every 5min...I need to "AUTO refresh " the grid for every 5 mins

Code am using:

XML

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

<asp:GridView ID="GridView2

VB

" runat="server" AutoGenerateColumns="False" DataKeyNames="CustomerID"
DataSourceID="SqlDataSource1" AllowPaging="True" AllowSorting="True">

Code behind:

C#

protected void Timer1_Tick(object sender, EventArgs e)
{
GridView2.DataBind();
}

But it is not working please help me ...

Posted 11-Jun-12 10:46am

myansweris

Add a Solution

6 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2012-06-11T19:53:00

Solution 5

Here:
Using UpdatePanel and Timer control: How to refresh an ASP.NET GridView automatically at regular intervals[^]

Using jQuery AJAX: How to Make GridView Auto Partial Update like Gmail Inbox[^]

Posted 11-Jun-12 19:53pm

Sandeep Mewara

Binu Varghese K · Answer 2 · 2012-06-11T19:40:00

Solution 3

you can either use a icallback or you can use a web service call to refresh the grid . use javascript timer to call this( either web service or icallback) at every 5 minutes...

Posted 11-Jun-12 19:40pm

Binu Varghese K

Christian Sanabria J · Answer 3 · 2014-07-16T18:38:00

Solution 10

Use SignalR --- the server notifies the client that it has to refresh the data

Posted 16-Jul-14 18:38pm

Christian Sanabria J

Phanindra Baddula · Answer 4 · 2014-07-16T18:42:00

XML

<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>

      <asp:Timer ID="Timer1" runat="server" Interval="20000" OnTick="Timer1_Tick"></asp:Timer>
 <asp:UpdatePanel runat="server">
          <ContentTemplate>
         <asp:GridView ID="DGVsa" runat="server"></asp:GridView>
          </ContentTemplate>
          <Triggers>
              <asp:AsyncPostBackTrigger ControlID="Timer1" EventName="Tick" />

          </Triggers>

      </asp:UpdatePanel>


in .Cs

protected void Timer1_Tick(object sender, EventArgs e)
       {
Gridbinding()

       }
public void Gridbinding()
{
        sqlSA = "SELECT * FROM Mas_Display"
        DGVsa.DataSource = con.ReturnQuery(sqlSA);
        DGVsa.DataBind();
}

Krishna Shidnekoppa · Answer 5 · 2015-11-27T23:21:00

Solution 12

You can refresh Grid by calling

C#

GridView1.DataBind();

Posted 27-Nov-15 23:21pm

Krishna Shidnekoppa

Comments

CHill60 30-Nov-15 4:31am

You have added nothing to the other solutions posted over 3 years ago. In fact your "solution" doesn't even suggest where to put this code.
Answering old questions like this will only attract downvotes and reports.

vithal wadje · Answer 6 · 2012-09-20T00:17:00

Solution 7

you can refer this link how to autorefresh gridview[^]

Posted 20-Sep-12 0:17am

vithal wadje

Updated 16-May-13 2:01am

v3